Question 16
You have a default installation of SQL Server that hosts an Online Transaction Processing (OLTP) application.
Users report that they experience poor overall query performance for the application.
You query the wait statistics and discover that the two top waits are CXPACKET and SOS_SCHEDULER_YIELD.
You need to modify the SQL Server settings to resolve the issue causing the poor query performance.
Which two settings should you modify? Each correct answer presents part of the solution.
Question 17
DRAG DROP
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to AutoShrink.
You need to create a policy to check the condition.
What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Question 18
You are designing a data warehouse with two fact tables.
The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?
Question 19
DRAG DROP
You have a server that has SQL Server 2016 installed.
You need to configure native SQL Server backups for a database named Customers. The solution must use backup encryption.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct orders.
Question 20
HOTSPOT
You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server.
Some of the applications are throwing errors because of insufficient memory.
You need to ensure that the other applications have sufficient memory.
Which setting should you configure?
