最新的Microsoft Querying Microsoft SQL Server 2012/2014 - 070-461免費考試真題
You have a database that contains the tables as shown in the exhibit. (Click the Exhibit button.)
You have the following query:
You need to recreate the query to meet the following requirements:
* Reference columns by using one-part names only.
* Sort aggregates by SalesTerritoryID, and then by ProductID.
* Order the results in descending order from SalesTerritoryID to ProductID.
* The solution must use the existing SELECT clause and FROM clause.
Which code segment should you use?
To answer, type the correct code in the answer area.
You have the following query:
You need to recreate the query to meet the following requirements:
* Reference columns by using one-part names only.
* Sort aggregates by SalesTerritoryID, and then by ProductID.
* Order the results in descending order from SalesTerritoryID to ProductID.
* The solution must use the existing SELECT clause and FROM clause.
Which code segment should you use?
To answer, type the correct code in the answer area.
正確答案: A
You use Microsoft SQL Server 2012 to develop a database application.
You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?
You need to implement a computed column that references a lookup table by using an INNER JOIN against another table.
What should you do?
正確答案: B
You administer a Microsoft SQL Server instance that will support several databases.
You need to ensure that every new database created has a data type named postalcode that contains the same attributes.
What should you do?
You need to ensure that every new database created has a data type named postalcode that contains the same attributes.
What should you do?
正確答案: A
說明：（僅 Fast2test 成員可見）
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table.
You discover that Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?
You discover that Sales_2.ndf is corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do?
正確答案: D
You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema.
You need to achieve this goal by using the minimum amount of administrative effort. What should you do?
You need to achieve this goal by using the minimum amount of administrative effort. What should you do?
正確答案: D
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You develop a database for a travel application. You need to design tables and other database objects.
You create the Historical_Events table.
You need to store dates by using the smallest possible storage size.
What should you do?
You develop a database for a travel application. You need to design tables and other database objects.
You create the Historical_Events table.
You need to store dates by using the smallest possible storage size.
What should you do?
正確答案: G
說明：（僅 Fast2test 成員可見）
You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?
There is high contention between readers and writers on several tables used by your transaction.
You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?
正確答案: C
說明：（僅 Fast2test 成員可見）
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You develop a database for a travel application. You create a view that displays details of events and attractions. The names of the event and attractions are sorted alphabetically.
You need to sort the names in a case-sensitive, dictionary order.
What should you do?
You develop a database for a travel application. You create a view that displays details of events and attractions. The names of the event and attractions are sorted alphabetically.
You need to sort the names in a case-sensitive, dictionary order.
What should you do?
正確答案: I
說明：（僅 Fast2test 成員可見）
You have a database that contains the tables as shown below:
You have a stored procedure named Procedure1. Procedure1 retrieves all order ids after a specific date. The rows for Procedure1 are not sorted. Procedure1 has a single parameter named Parameter1. Parameter1 uses the varchar type and is configured to pass the specific date to Procedure1. A database administrator discovers that OrderDate is not being compared correctly to Parameter1 after the data type of the column is changed to datetime. You need to update the SELECT statement to meet the following requirements:
The code must NOT use aliases.
The code must NOT use object delimiters.
The objects called in Procedure1 must be able to be resolved by all users.
OrderDate must be compared to Parameter1 after the data type of Parameter1 is changed to datetime.
Which SELECT statement should you use?
To answer, type the correct code in the answer area.
You have a stored procedure named Procedure1. Procedure1 retrieves all order ids after a specific date. The rows for Procedure1 are not sorted. Procedure1 has a single parameter named Parameter1. Parameter1 uses the varchar type and is configured to pass the specific date to Procedure1. A database administrator discovers that OrderDate is not being compared correctly to Parameter1 after the data type of the column is changed to datetime. You need to update the SELECT statement to meet the following requirements:
The code must NOT use aliases.
The code must NOT use object delimiters.
The objects called in Procedure1 must be able to be resolved by all users.
OrderDate must be compared to Parameter1 after the data type of Parameter1 is changed to datetime.
Which SELECT statement should you use?
To answer, type the correct code in the answer area.
正確答案: A
說明：（僅 Fast2test 成員可見）