Online Access Free DP-300 Practice Test

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?

• A.a table that has a FOREIGN KEY constraint
• B.a user-defined SEQUENCE object
• C.a table the has an IDENTITY property
• D.a system-versioned temporal table

You have an Azure subscription that is linked to an Azure AD tenant named contoso.com. The subscription contains an Azure SQL database named SQL 1 and an Azure web named app1. App1 has the managed identity feature enabled.
You need to create a new database user for app1.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

https://learn.microsoft.com/en-us/azure/app-service/tutorial-connect-msi-sql-database?tabs=windowsclient%
2Cef%2Cdotnet
Basic Concept: This question tests identity and authentication for Azure SQL and SQL Server workloads, including when to use contained users, directory identities, certificate validation, or authentication profiles.
Why the selected answer is Correct: The selected values fit this scenario because they apply the required Azure SQL configuration at the correct scope and sequence: You need to create a new database user for app1.
Why the alternate choices are Wrong: The alternate actions fail because Entra authentication must be established at the server/administrator level first, then mapped to contained database users, and finally used by the client connection.

You have an Azure subscription that contains a resource group named RG1 RG1 contains an Azure SQL managed instance named MM.
You use an Azure Resource Manager (ARM) template to update the properties of MM.
You need to monitor the management operations of Mil. The solution must ensure that you can review the operation parameters and step-level progress of the operations.
What should you use?

• A.Azure Monitor
• B.the SQL Managed Instance operations API
• C.the deployment history of RG1
• D.the Azure Activity log

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.an ExpressRoute gateway
• C.a private link
• D.a service endpoint

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to replicate DB1 to SQlDC1.
Which type of replication should you use?

• A.merge
• B.peer-to-pec
• C.snapshot
• D.transactional