QUESTION NO: 1
You review a query that runs slowly. The query accesses data in a table named Schema1.Table1.
The following is the relevant portion of the execution plan for the query:
You need to create the missing index.
Which code segment should you execute?
You review a query that runs slowly. The query accesses data in a table named Schema1.Table1.
The following is the relevant portion of the execution plan for the query:
You need to create the missing index.
Which code segment should you execute?
Correct Answer: A
Vote an answer
QUESTION NO: 2
You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
Correct Answer: C
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 3
You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent users.
You need to log all of the queries to DB1 that become deadlocked. The solution must meet the following requirements:
- Provide a representation of the deadlock in XML format.
- Minimize the impact on the server.
What should you create?
You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent users.
You need to log all of the queries to DB1 that become deadlocked. The solution must meet the following requirements:
- Provide a representation of the deadlock in XML format.
- Minimize the impact on the server.
What should you create?
Correct Answer: B
Vote an answer
QUESTION NO: 4
DRAG DROP
You plan to create a custom aggregation function named Median.
You plan to deploy Median to a SQL Server 2014 server named Server1.
You need to ensure that Median can access a web service named WebApp1. The solution
must minimize the number of changes made to the database.
You create a Microsoft .NET Framework class that contains the definition of Median.
You upload a certificate to Server1.
What three tasks should you perform next?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DRAG DROP
You plan to create a custom aggregation function named Median.
You plan to deploy Median to a SQL Server 2014 server named Server1.
You need to ensure that Median can access a web service named WebApp1. The solution
must minimize the number of changes made to the database.
You create a Microsoft .NET Framework class that contains the definition of Median.
You upload a certificate to Server1.
What three tasks should you perform next?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
QUESTION NO: 5
DRAG DROP
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014.
You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
DRAG DROP
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014.
You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment.
Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
Correct Answer:
QUESTION NO: 6
You execute the following code:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to prevent the key lookup.
What should you modify?
More than one answer choice may achieve the goal. Select the BEST answer.
You execute the following code:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to prevent the key lookup.
What should you modify?
More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: A
Vote an answer
QUESTION NO: 7
You have a database that uses the following management views:
----
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?
You have a database that uses the following management views:
----
Sys.dm_os_volume_stats
Sys.dm_db_partition_stats
Sys.dm_db_file_space_usage
Sys.fulltext_indexes
You plan to migrate the database to Microsoft SQL Azure.
You need to identify which view can be used in SQL Azure.
Which view should you identify?
Correct Answer: A
Vote an answer
QUESTION NO: 8
You need to recommend a solution to ensure that USP_4 adheres to the security requirements.
What should you include in the recommendation?
You need to recommend a solution to ensure that USP_4 adheres to the security requirements.
What should you include in the recommendation?
Correct Answer: B
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 9
You need to convert the functionality of Legacy.sql to use a stored procedure. Which code segment should the stored procedure contain?
You need to convert the functionality of Legacy.sql to use a stored procedure. Which code segment should the stored procedure contain?
Correct Answer: D
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).