最新的Microsoft Developing Microsoft SQL Server Databases - 70-464免費考試真題
You need to ensure that usp_AddXMLOrder can be used to validate the XML input from the retailers.
Which parameters should you add to usp_AddXMLOrder on line 04 and line 05? (Each correct answer presents part of the solution. Choose all that apply.)
Which parameters should you add to usp_AddXMLOrder on line 04 and line 05? (Each correct answer presents part of the solution. Choose all that apply.)
正確答案: A,C
You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.
Schema1.Udf1 was defined by using the following code:
You need to write a query that will contain the following columns:
* Country
* CountryID
* CustomerName
The solution must meet the following requirements:
* Rows must be returned only if the function returns data.
* The amount of time it takes the query to execute must be minimized.
Which query should you use?
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.
Schema1.Udf1 was defined by using the following code:
You need to write a query that will contain the following columns:
* Country
* CountryID
* CustomerName
The solution must meet the following requirements:
* Rows must be returned only if the function returns data.
* The amount of time it takes the query to execute must be minimized.
Which query should you use?
正確答案: B
You have a table named Table1 that contains one million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type. You have a certificate named Cert1.
You must add a column named Column2 that contains an encrypted version of the data from Column1. You must use two-way encryption. You plan to remove Column1 after you create Column2.
Which five Transact-SQL statements should you run in sequence before you remove Column1? To answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any correct orders you select.
You must add a column named Column2 that contains an encrypted version of the data from Column1. You must use two-way encryption. You plan to remove Column1 after you create Column2.
Which five Transact-SQL statements should you run in sequence before you remove Column1? To answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any correct orders you select.
正確答案:
Explanation:
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/close-symmetric-key-transact-sql?view=sql-server-2017
You need to ensure that a new execution plan is used by usp_GetOrdersByProduct each time the stored procedure runs.
What should you do?
What should you do?
正確答案: C
You need to convert the functionality of Legacy.sql to use a stored procedure.
Which code segment should the stored procedure contain?
Which code segment should the stored procedure contain?
正確答案: A
說明：（僅 Fast2test 成員可見）
You create a table named Customers by using the following code segment:
You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:
You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?
You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:
You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?
正確答案: C
You need to create a function that will use a SELECT statement in ProductsByProductType.sql.
Which code segment should you use to complete the function?
Which code segment should you use to complete the function?
正確答案: B
說明：（僅 Fast2test 成員可見）
You have a SQL Server 2012 database that contains a table named Users. The Users table contains usernames and passwords.
You need to ensure that all new records have a password.
Which code segment should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
You need to ensure that all new records have a password.
Which code segment should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
正確答案: A
You need to implement a new version of usp_AddMobileLocation. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks.
正確答案:
Explanation:
Note:
* From scenario:
The mobile application will need to meet the following requirements:
* Update the location of the user by using a stored procedure named usp_AddMobileLocation.
* DELAYED_DURABILITY
SQL Server transaction commits can be either fully durable, the SQL Server default, or delayed durable (also known as lazy commit).
Fully durable transaction commits are synchronous and report a commit as successful and return control to the client only after the log records for the transaction are written to disk. Delayed durable transaction commits are asynchronous and report a commit as successful before the log records for the transaction are written to disk. Writing the transaction log entries to disk is required for a transaction to be durable. Delayed durable transactions become durable when the transaction log entries are flushed to disk.
You create a disk-based table that contains the following script:
You need to prevent duplicate values in the SKU field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
You need to prevent duplicate values in the SKU field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
正確答案:
Explanation:
Note: The SQL command is:
ALTER TABLE <tablename> ADD CONSTRAINT
<constraintname> UNIQUE
(
<columnname>
)