You have an Azure SQL database.
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurations Transact-SQL command
and receive the results shown in the following table
You need relieve the memory pressure.
What should you configure?

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest
query performance.
What should you use for the surrogate key?

You are building a database backup solution for a SQL Server database hosted on an
Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database
backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?

You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB
database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run
on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move
the appropriate actions from the list of actions to the answer area and arrange them in the
correct.

You have an Azure data solution that contains an enterprise data warehouse in Azure
Synapse Analytics named DW1.
Several users execute adhoc queries to DW1 concurrently.
You regularly perform automated data loads to DW1.
You need to ensure that the automated data loads have enough memory available to
complete quickly and
successfully when the adhoc queries run.
What should you do?

You have an instance of SQL Server on Azure Virtual Machines that has a database
named DB1.
You plan to implement Azure SQL Data Sync for DB1.
Which isolation level should you configure?

From a website analytics system, you receive data extracts about user interactions such as
downloads, link clicks, form submissions, and video plays.
The data contains the following columns:

You have an Azure SQL database that contains a table named Employees. Employees
contains a column named Salary.
You need to encrypt the Salary column. The solution must prevent database administrators
from reading the data in the Salary column and must provide the most secure 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 order.