Free Administering Relational Databases on Microsoft Azure Exam DP-300 Exam Practice Test

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.Solution: You restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the REPLACE option.Does this meet the goal?

• Yes
• No

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.Does this meet the goal?

• Yes
• No

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.You need to recommend a deployment solution that meets the following requirements:* Provides a Service Level Agreement (SLA) of at least 99.95%* Replicates databases in the same group synchronously* Minimizes the latency of database writesWhat should you recommend?

• Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group.
• Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.
• Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.
• Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

You have an Azure SQL Database managed instance.The instance starts experiencing performance issues.You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.What should you use?

• the Azure portal
• Extended Events
• Query Store
• dynamic management views

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have an Azure Data Lake Storage account that contains a staging zone.You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes an Azure Databricks notebook, and then inserts the data into the data warehouse.Does this meet the goal?

• Yes
• No

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.What should you include in the recommendation?

• Resource Governor
• a custom resource pool
• vertical scaling
• horizontal scaling

You have an Azure SQL database named SOL1.You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:* The recovery point objective JRPO)* The recovery time objective (RTO)* Administrative effortWhat should you include in the solution?

• auto failover groups
• Azure Site Recovery
• availability groups
• active geo - replication

You have an Azure SQL database named db1 on a server named server1.The Intelligent Insights diagnostics log identifies that several tables are missing indexes.You need to ensure that indexes are created for the tables.What should you do?

• RuntheDBCC SQLPERF command.
• Run the dbcc dbreindex command.
• Modify the automatic tuning settings for db1.
• Modify the Query Store settings for db1.

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1.DF1 contains a linked service.You have an Azure Key vault named vault1 that contains an encryption kay named key1.You need to encrypt df1 by using key1.What should you do first?

• Disable purge protection on vault1.
• Remove the linked service from df1.
• Create a self-hosted integration runtime.
• Disable soft delete on vault1.

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2.On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1.You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege.Which role should you assign to User2?

• sysadmin
• SQLAgentUserRole
• SQLAgentOperatorRole
• SQLAgentReaderRole