Practice Free DP-300 Exam Online Questions
You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.
You plan to implement a disaster recovery solution.
You need to be able to perform disaster recovery drills regularly.
The solution must meet the following requirements:
• Minimize administrative effort for the recovery drills.
• Isolate the recovery environment from the production environment.
What should you use?
- A . Recovery Services vaults
- B . Azure Site Recovery
- C . Azure Backup
- D . native Microsoft SQL Server backup
You need to recommend a process to automate the management of DB3. The solution must meet the management requirements.
What should be the first step of the process?
- A . Configure Microsoft Entra authentication for the logical server that hosts DB3.
- B . Create a database that has database-scoped credentials.
- C . Configure a private endpoint for connectivity to DB3.
- D . Create data base-scoped credentials in DB3.
You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Enable query optimizer fixes.
- B . Enable Resource Governor.
- C . Enable parameter sniffing.
- D . Create a workload group.
- E . Configure In-memory OLTP.
- F . Run the Database Engine Tuning Advisor.
- G . Reduce the Max Degree of Parallelism value.
B, D
Explanation:
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-ver15
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.
You create a master key in the master database of SQL1.
You need to create an encrypted backup of DB1.
What should you do?
- A . Create a symmetric key in DB1.
- B . Enable visualization-based security (VBS) on Server1.
- C . Create a certificate in DB1.
- D . Create a certificate in the master database of SQLl.
You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest query performance.
What should you use for the surrogate key?
- A . an IDENTITY column
- B . a GUID column
- C . a sequence object
A
Explanation:
Dedicated SQL pool supports many, but not all, of the table features offered by other databases.
Surrogate keys are not supported. Implement it with an Identity column.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tablesoverview
You need to identify the event_flle 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
You have an Azure subscription that contains the following resources:
• 10 Azure SQL databases
• Five Azure SQL managed instances
• Five instances of SQL Server on Azure Virtual Machines
You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort.
What should you include in the solution?
- A . Log Analytics
- B . Azure SQL Analytics
- C . Query Performance Insight
- D . SQL Insights
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?
- A . JSON
- B . CSV
- C . Parquet
- D . ORC
C
Explanation:
Serverless SQL pool can automatically synchronize metadata from Apache Spark. A serverless SQL
pool database will be created for each database existing in serverless Apache Spark pools.
For each Spark external table based on Parquet and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool.
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables
You have an Azure subscription that contains a user named user1 and an Azure SQL database named OBI. You configure long-term retention (LTR) for DB1.
You need to ensure that User1 can delete LTR backups of DBl. The solution must follow the principle of least privilege.
Which role should you assign to User1?
- A . SQL Server Contributor
- B . Owner
- C . SQL Security Manager
- D . Contributor
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.
A
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry