MCITPMCITP(70-441)单项选择题每日一练(2018.10.31)

单项选择题
You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements.Which type of Transact-SQL stored procedure should you use?（）
A.one that uses an internal SQL Server Web service endpoint
B.one that runs a SQL Server Integration Services （SSIS） package
C.one that uses Service Broker
D.one that runs a user-defined function
单项选择题
You need to ensure that the Cust_CalcData column is implemented appropriately. What should you do?（）
A.Specify that the Cust_CalcData column must be implemented as a computed column of the table.
B.Specify that the Cust_CalcData column must be indexed using a non-clustered index.
C.Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.
D.Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.
单项选择题
You need to design the storage of the application texts for UI elements to fulfill the requirements. Which table and column design should you use?（）
A.Languages (LanguageID, Name)Elements (ElementID, Description)ElementLanguages (ElementID, LanguageID, Text)
B.Languages (LanguageID, Name)Elements (ElementID, LanguageID, Description, Text)
C.Languages (LanguageID, Name)ElementTexts (LanguageID, Text)ElementDescriptions (ElementID, Description)
D.Languages (LanguageID, Name)Elements (ElementID, Description, Text)
单项选择题
You need to design the Service Broker queues that will be used to submit requests for long-running reports. Your solution must minimize complexity of using the queues by applications.What should you do?（）
A.Specify one queue for each client application that can submit report requests.
B.Specify one queue for each of the two report-generation services.
C.Specify one queue for all long-running report requests.
D.Specify eight queues：One for each service， and one for each client application.
单项选择题
You need to ensure that old data and current data can be queried according to the business requirements. What should you do?（）
A.Specify a view based on the archival data table and current data tables.
B.Specify that the data must be queried by using a stored procedure.
C.Specify that both the archival data table and the current data tables must have indexes created on the same columns.
D.Specify that a SQL Server Agent job must be used to copy current data into the archival data table each night.