Practice Free DP-300 Exam Online Questions
DRAG DROP
You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2.
You have an Azure subscription
You need to sync a subset of tables between the databases hosted on SQL1 and SQL2 by using SQL Data Sync.
Which five actions should you perform in sequence’ To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
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
HOTSPOT
You have an Azure subscription that contains the resources shown in the following table.
You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
SIMULATION
Task 5
You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.
HOTSPOT
You have an Azure subscription that contains an Always On availability group named AG1. AG1 contains three replicas named Server1. Server2. and Server3.
You execute the following T-SQL statements on Server1.
For each of the following statements, select Yes if the statement is true, otherwise select No. NOTE: Each correct selection is worth one point.
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.
Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
What should you include in the recommendation?
- A . Azure Backup
- B . Azure Information Protection
- C . Windows Server Failover Cluster
- D . Azure Site Recovery
You have an instance of SQL Server on Azure Virtual Machines.
You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs.
The solution must use the principle of least privilege.
Which role should you assign to User1?
- A . sysadmin
- B . SQLAgentUserRole
- C . SQLAgentReaderRole
- D . SQLAgentOperatorRole
You have an Azure subscription
You plan to create an instance of SQL Server on Azure Virtual Machines. You need to ensure that the instance is resilient against datacenter failures.
What should you use?
- A . an availability set
- B . Azure Site Recovery
- C . an availability zone
- D . a proximity placement group
You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.
What should you use as the event_file target?
- A . an Azure SQL database
- B . an Azure Blob Storage container
- C . a SQL Server filegroup
- D . an Azure Files share
DRAG DROP
Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.
You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.
