You need to design the storage of the loan response message. Which actions or actions should you perform?（）A、Use the xml data type to store the message.B、Use a user-defined data type to store the message.C、Use the nvarchar（max） data type to store the mess

题目

You need to design the storage of the loan response message. Which actions or actions should you perform?（）

  • A、Use the xml data type to store the message.
  • B、Use a user-defined data type to store the message.
  • C、Use the nvarchar（max） data type to store the message.
  • D、Use a check constraint to validate that the correct tags are used.
  • E、Use an XML schema definition （XSD） to validate that the correct tags are used.
  • F、Use a foreign key constraint to validate that the correct tags are used.
相似考题

1.You need to serialize an object of type List<int> in a binary format.The object is named data.Which code segment should you use?()A.B.C.D.

2. You are designing a Windows Azure application that will use Windows Azure Table storage.  You need to recommend an approach for minimizing storage costs.  What should you recommend？ （）A、 Use Entity Group Transactions.B、 Use multiple partitions to store data.C、 Use a transaction scope to groupall storage operations.D、 Use Microsoft Distributed Transaction Coordinator （MSDTC）.

3.You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

4.Your mobile device runs the latest version of the Microsoft Windows Mobile operating system.Your mobile device supports the use of Bluetooth and Infrared (IR) for data synchronization. You need to configure data synchronization on your computer to only use Bluetooth.Which three actions should you perform?（）A.AB.BC.CD.DE.EF.F

更多“You need to design the storage of the loan response message. Which actions or actions should you perform?（）A、Use the xml data type to store the message.B、Use a user-defined data type to store the message.C、Use the nvarchar（max） data type to store the mess”相关问题

  • 第1题：

    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

    • A、An object type is a user-defined composite data type. 
    • B、The attributes of an object type can be those of other object types. 
    • C、A PL/SQL table of records is an example of a nested object type. 
    • D、An object type must be declared as a type before the actual object itself can be declared.

    正确答案:A,B,D

  • 第2题：

    You have to store user data of 200 KB in an object. Which state management technique to use：（）

    • A、Server session
    • B、Cookie
    • C、ViewState
    • D、Hidden Field

    正确答案:A

  • 第3题：

    You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding， the Session objects are not lost.  What should you do？（）

    • A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
    • B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
    • C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
    • D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

    正确答案:B

  • 第4题：

    You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You use the ClickOnce deployment methodology to distribute the application. You need to store application-specific data along with read/write permissions without requiring elevated permissions for the application. Where should you store the application data?（）

    • A、 In isolated storage.
    • B、 On the database server.
    • C、 In the ClickOnce data directory.
    • D、 In the App.config file of the application.

    正确答案:A

  • 第5题：

    You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?（）

    • A、Symmetric key encryption
    • B、Asymmetric key encryption
    • C、Certificate-based encryption
    • D、Transparent data encryption

    正确答案:A

  • 第6题：

    You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend？（）

    • A、 Use a separate table for each date.  Delete eachtable when it is one week old.
    • B、 Use a separate table for each week.  Delete each table when it is one week old.
    • C、 Use a single table， partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.
    • D、 Use a single table， partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.

    正确答案:A

  • 第7题：

    You work as an application developer at CER-Tech.com. Cert-Tech.com uses Visual studio.NET 2005 as its Application Development platform.You are developing a .NET Framework 2.0 application used to store a type-safe list of names and e-mail addresses. The list will be populated all at ones from the sorted data which means you will not always need to perform insertion or deletion operations on the data. You are required to choose a data structure that optimizes memory use and has good performance.What should you do？（）

    • A、 The System.Collections.Generic.SortedList class should be used 
    • B、 The System.Collections.HashTable class should be used
    • C、 The System.Collections.Generic.SortedDictionary class should be used 
    • D、 The System.Collections.SortedList class should be used

    正确答案:A

  • 第8题：

    单选题
    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）
    A

     Use Windows Azure Queues.

    B

     Use Windows Live Mesh 2011.

    C

     Use a single SQL Azure database.

    D

     Use Windows Azure Table storage


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You are designing a Windows Azure application that will use Windows Azure Table storage.  You need to recommend an approach for minimizing storage costs.  What should you recommend？ （）
    A

     Use Entity Group Transactions.

    B

     Use multiple partitions to store data.

    C

     Use a transaction scope to groupall storage operations.

    D

     Use Microsoft Distributed Transaction Coordinator （MSDTC）.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements：   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend？（）
    A

     Use Windows Azure Queues.

    B

     Use a single SQL Azure database.

    C

     Use a single Windows Azure Drive.

    D

     Use Windows Azure Table storage.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）
    A

    Use NTFS file system compression on the volume.

    B

    Use row-level compression on the document table.

    C

    Use varbinary(MAX) data type with FILESTREAM storage.

    D

    Enable row-level compression on all columns that use the vardecimal() data type.


    正确答案： D,A
    解析： 暂无解析

  • 第13题：

    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）

    • A、 Use Windows Azure Queues.
    • B、 Use Windows Live Mesh 2011.
    • C、 Use a single SQL Azure database.
    • D、 Use Windows Azure Table storage

    正确答案:D

  • 第14题：

    Your company has client computers that run Windows XP Professional.   You are planning to install Windows 7 Enterprise on the existing client computers.    You need to design a user state migration strategy that minimizes network bandwidth and server use when user data is being migrated.   What should you do？（）

    • A、Use the Refresh Computer method and a hard-link migration store.
    • B、Use the Refresh Computer method and a compressed migration store.
    • C、Use the Replace Computer method and a hard-link migration store.
    • D、Use the Replace Computer method and a compressed migration store.

    正确答案:A

  • 第15题：

    You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements：   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend？（）

    • A、 Use Windows Azure Queues.
    • B、 Use a single SQL Azure database.
    • C、 Use a single Windows Azure Drive.
    • D、 Use Windows Azure Table storage.

    正确答案:B

  • 第16题：

    You discover that a particular group of settings named UserPreferences changes.You need to store the UserPreference settings to prevent affecting other applications. Which two actions should you perform？（）

    • A、Use the Properties.USerPreferences object
    • B、Use the Properties.Settings.Default.Userprefences object
    • C、Use the ConfigurationManager.AppSettings object during runtime
    • D、Create the settings by using Application scope
    • E、Create the settings by using User scope

    正确答案:B,E

  • 第17题：

    You work as the application developer at Certkiller .com. Certkiller .com uses Visual Studio.NET 2005 as its application development platform.You are developing a .NET Framework 2.0 application used to store a type-safe list of names and e-mail addresses. The list will be populated all at ones from the sorted data which means you well not always need to perform insertion or deletion operations on the data. You are required to choose a data structure that optimizes memory use and has good performance.What should you do？（）

    • A、 The System.Collections.Generic.SortedList class should be used
    • B、 The System.Collections.HashTable class should be used
    • C、 The System.Collections.Generic.SortedDictionary class should be used
    • D、 The System.Collections.SortedList class should be used

    正确答案:A

  • 第18题：

    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）

    • A、Use NTFS file system compression on the volume.
    • B、Use row-level compression on the document table.
    • C、Use varbinary(MAX) data type with FILESTREAM storage.
    • D、Enable row-level compression on all columns that use the vardecimal() data type.

    正确答案:A,C

  • 第19题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a n On-Line Analytical Processing （OLAP） database named in the instance. The database contains a dimension table named Clients. Ever hour backup of data of the Clients table is performed. But the Clinets table contains redundant data. You must keep the disk space used to store the Clients table.  In the options below， which compression technology should you use？（）

    • A、You should use row compression 
    • B、You should use page compression 
    • C、You should use backup compression 
    • D、You should use windows NTFS file system compression

    正确答案:B

  • 第20题：

    单选题
    You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You use the ClickOnce deployment methodology to distribute the application. You need to store application-specific data along with read/write permissions without requiring elevated permissions for the application. Where should you store the application data?（）
    A

     In isolated storage.

    B

     On the database server.

    C

     In the ClickOnce data directory.

    D

     In the App.config file of the application.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    多选题
    You need to design the storage of the loan response message. Which actions or actions should you perform?（）
    A

    Use the xml data type to store the message.

    B

    Use a user-defined data type to store the message.

    C

    Use the nvarchar（max） data type to store the message.

    D

    Use a check constraint to validate that the correct tags are used.

    E

    Use an XML schema definition （XSD） to validate that the correct tags are used.

    F

    Use a foreign key constraint to validate that the correct tags are used.


    正确答案： A,E
    解析： 暂无解析

  • 第22题：

    单选题
    You are designing an application that will use Windows Azure Table storage to store millions of data points each day.  The application must retain each day’s data for only one week.   You need to recommend an approach for minimizing storage transactions.  What should you recommend？（）
    A

     Use a separate table for each date.  Delete eachtable when it is one week old.

    B

     Use a separate table for each week.  Delete each table when it is one week old.

    C

     Use a single table， partitioned by date.  Use Entity Group Transactions to delete data when it is one week old.

    D

     Use a single table， partitioned by week.  Use Entity Group Transactions to delete data when it is one week old.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）
    A

    You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 

    B

    You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    C

    You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 

    D

    You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 


    正确答案： C
    解析： 暂无解析

相关内容