You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options
in the answer area.
NOTE: Each correct selection is worth one point.

You configure version control for an Azure Data Factory instance as shown in the following
exhibit.

Use the drop-down menus to select the answer choice that completes each statement
based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

You have an Azure Data Factory pipeline that is triggered hourly.
The pipeline has had 100% success for the past seven days.
The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.

What is a possible cause of the error?

A. From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.

B. The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.

C. From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.

D. The pipeline was triggered too early.

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.
Data to be loaded is identified by a column named LastUpdatedDate in the source table.
You plan to execute the pipeline every four hours.
You need to ensure that the pipeline execution meets the following requirements:
Automatically retries the execution when the pipeline run fails due to concurrency or
throttling limits.
Supports backfilling existing data in the table.
Which type of trigger should you use?

A. tumbling window

B. on-demand

C. event

D. schedule

You have an Azure subscription that contains an Azure SQL database. The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.
You need to resolve the performance issues.
What should you do?

A. Implement memory-optimized tables

B. Run the dbcc flushprocindB command.

C. Replace the sequential index keys with nonsequential keys.

D. Run the dbcc dbreindex command

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?

A. SERIALIZABLE

B. SNAPSHOT

C. READ UNCOMMITTED

D. READ COMMITTED

You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?

A. log shipping

B. Always On availability groups

C. Database Migration Assistant

D. Backup and Restore

A company plans to use Apache Spark analytics to analyze intrusion detection data.
You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts.
What should you recommend?

A. Azure Data Lake Storage

B. Azure Databricks

C. Azure HDInsight

D. Azure Data Factory

You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?

A. Use the Agent XPs option.

B. Enable the SQL Server Agent.

C. Run the sp_configure command

D. Run the sp set_agent properties command.

You have an Azure subscription that contains the resources shown in the following table.

You need to configure a connection between VM1 and MIL The solution must meet the
following requirements:
• The connection must be encrypted.
• Network latency must be minimized.

A. virtual network peering

B. private endpoints

C. service endpoints

D. a site-to-site VPN

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?

A. Assign a smaller resource class to the automated data load queries.

B. Create sampled statistics to every column in each table of DW1

C. Assign a larger resource class to the automated data load queries

D. Hash distribute the large fact tables in DW1 before performing the automated data loads.