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

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 Implement a Secure Environment Question Set 1

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?

• A.DBCC SHRINKDATABASE
• B.sp_clean_db_free_space
• C.sp_clean_db_file_free_space
• D.DBCC SHRINKFILE

Comment: *

Name: *

Email: *

Verification: *

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
Restrict network connectivity to SqlSrv1.
What should you create on VNet1?

• A.a VPN gateway
• B.a service endpoint
• C.a private link
• D.an ExpressRoute gateway

Comment: *

Name: *

Email: *

Verification: *

You are evaluating the role assignments.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

Comment: *

Name: *

Email: *

Verification: *

You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
Which resource type should you use to create the alert?

• A.Resource Groups
• B.SQL Servers
• C.SQL Databases
• D.SQL Virtual Machines

Comment: *

Name: *

Email: *

Verification: *