Practice Free DP-300 Exam Online Questions
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.
You need to configure SQL1 to use mixed mode authentication.
Which procedure should you run?
- A . sp_eddremotelogin
- B . xp_grant_login
- C . sp_change_users_login
- D . xp_instance_regwrite
HOTSPOT
You have an Azure SQL database.
You need to identify whether a delayed query execution is associated to a RESOURCE wait.
How should you complete the Transact CSQL statement? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point.
You are evaluating the business goals.
Which feature should you use to provide customers with the required level of access based on their service agreement?
- A . dynamic data masking
- B . Conditional Access in Azure
- C . service principals
- D . row-level security (RLS)
D
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15
You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five minute intervals and report only events that arrive during the interval.
The output will be sent to a Delta Lake table.
Which output mode should you use?
- A . complete
- B . append
- C . update
A
Explanation:
Complete mode: You can use Structured Streaming to replace the entire table with every batch.
Incorrect Answers:
B: By default, streams run in append mode, which adds new records to the table.
Reference: https://docs.databricks.com/delta/delta-streaming.html
HOTSPOT
Vou have an Azure SQL database named DB1.
You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.
You need to implement a database-level firewall that meets the following requirements:
• Ensures that only the 10 virtual machines can access DB1
• Follows the principle of least privilege
How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You need to recommend a solution to meet the security requirements and the business requirements for DB3.
What should you recommend as the first step of the solution?
- A . Run the sys.5p_cdc_en«ble_db stored procedure.
- B . Run the alter table statement and specify the enable chahgc_tracking clause.
- C . Run the alter database statement and specify the set cmange_trackinc> – on clause.
- D . Run the sp_addarticle stored procedure.
You need to recommend a solution to meet the security requirements and the business requirements for DB3.
What should you recommend as the first step of the solution?
- A . Run the sys.5p_cdc_en«ble_db stored procedure.
- B . Run the alter table statement and specify the enable chahgc_tracking clause.
- C . Run the alter database statement and specify the set cmange_trackinc> – on clause.
- D . Run the sp_addarticle stored procedure.
HOTSPOT
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-managed-instance-online
You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort.
Where should you store the metrics?
- A . a Log Analytics workspace
- B . Azure Event Hubs
- C . Azure SQL Database
- D . an Azure Blob storage container
You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
Automate the patching of SQL Server and Windows Server.
Automate full database backups and transaction log backups of the databases on VM1.
Minimize administrative effort.
What should you do first?
- A . Enable a system-assigned managed identity for VM1
- B . Register VM1 to the Microsoft.Sql resource provider
- C . Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1
- D . Register VM1 to the Microsoft.SqlVirtualMachine resource provider
D
Explanation:
Automated Patching depends on the SQL Server infrastructure as a service (IaaS) Agent Extension. The SQL
Server IaaS Agent Extension (SqlIaasExtension) runs on Azure virtual machines to automate administration tasks. The SQL Server IaaS extension is installed when you register your SQL Server VM with the SQL Server VM resource provider.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extensionautomate-management