You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.
Which resource provider should you enable?

• A.Microsoft.EventHub
• B.Microsoft.EventGrid
• C.Microsoft.Sql
• D.Microsoft.Automation

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:
Minimize costs.
Aggregate Intelligent Insights telemetry from each database.
What should you do?

• A.From the Diagnostic settings of each database, select Send to Log Analytics.
• B.From the Diagnostic settings of each database, select Stream to an event hub.
• C.From the Diagnostic settings of SQLMI1. select Send to Log Analytics.
• D.From the Diagnostic settings of SQLMI1. select Stream to an event hub.

Comment: *

Name: *

Email: *

Verification: *

You deploy a database to an Azure SQL Database managed instance.
You need to prevent read queries from blocking queries that are trying to write to the database.
Which database option should set?

• A.PARAMETERIZATION to FORCED
• B.PARAMETERIZATION to SIMPLE
• C.Delayed Durability to Forced
• D.READ_COMMITTED_SNAPSHOT to ON

Comment: *

Name: *

Email: *

Verification: *

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016
database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate
instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative
effort.
What should you include in the recommendation?

• A.Azure SQL Managed instance
• B.Azure SQL Database single database
• C.Azure Database for PostgreSQL
• D.SQL Server on Azure virtual machines

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
* Clustered columnstore indexes
* Automatic tuning
* Change tracking
* PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?

• A.Clustered columnstore indexes
• B.PolyBase
• C.Change tracking
• D.Automatic tuning

Correct Answer: B

Section: [none]
Explanation:
This table lists the key features for PolyBase and the products in which they're available.

Incorrect Answers:
C: Change tracking is a lightweight solution that provides an efficient change tracking mechanism for applications. It applies to both Azure SQL Database and SQL Server.
D: Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

Comment: *

Name: *

Email: *

Verification: *