70-762 Sample Questions & Answers

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements.

A reporting database contains a non-partitioned fact table, which is persisted on disk. The following problems exist with regards to the table:

The completion of user queries is a lengthy process.
The table requires excessive storage in the database.
Indexes on the table are nonexistent.
A number of columns include repeating values.

You want to make use of an index that is the most effective at sorting out the problems listed.
Solution: You create a hash index on the table. Has the requirement been satisfied?

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result.

You have been tasked with creating two modules for a database with disk-based tables and memory-optimized tables.
You are informed that encryption should be configured for the first module via the ENCRYPTION option. The first module should allow for updates on disk-based tables and memory-optimized tables, as well as support OUTPUT parameters.

You are also informed that the second module should only access memory-optimized tables, and allow for updates on those tables. Furthermore, the second module should allow for substantial aggregations with maximum execution, as well as support OUTPUT parameters. Which of the following should you use for the first module?

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements.
You tasked with troubleshooting the performance issues of a Microsoft Azure SQL Database V12 database that has the database query store disabled. You intend making use of Query Performance Insight to complete this task.
You plan to make use of Transact-SQL statements to enable the database query store via SQL Server Managements Studio. The database query store should be configured to allow for statistics to be collected four times in the space of an hour, and should not exceed 1 GB of storage. Furthermore, query data should be kept for a minimum of twenty days. Lastly, the capturing of queries should be determined by the consumption of resources.
Solution: You write Transact-SQL statements that sets the Query Store Capture Mode to ALL.
Has the requirement been satisfied?

Note: The question is included in a number of questions that depicts the identical set-up. However, every question has a distinctive result. Establish if the solution satisfies the requirements.
You tasked with troubleshooting the performance issues of a Microsoft Azure SQL Database V12 database that has the database query store disabled. You intend to make use of Query Performance Insight to complete this task.
You plan to make use of Transact-SQL statements to enable the database query store via SQL Server Management Studio. The database query store should be configured to allow for statistics to be collected four times in the space of an hour, and should not exceed 1 GB of storage. Furthermore, query data should be kept for a minimum of twenty days. Lastly, the capturing of queries should be determined by the consumption of resources.
Solution: You write Transact-SQL statements that includes DATA_FLUSH_INTERVAL_SECONDS.
Has the requirement been satisfied?