Microsoft Microsoft Certifications DP-300 Questions & Answers

• Question 181:

  You plan to move two 100-GB databases to Azure.

  You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.

  What should you use?

  A. An Azure SQL Database elastic pool

  B. SQL Server on Azure virtual machines

  C. an Azure SQL Database managed instance

  D. Azure SQL databases

  Correct Answer: A

  Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

• Question 182:

  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 run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 183:

  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?

  A. Yes

  B. No

  Correct Answer: B

  There is no REPLACE option in Azure SQL Database, or even there is no restore option with T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql-dbandtabs=azure-portal

• Question 184:

  You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.

  You need to initiate a full backup of DB1 on SQL2.

  Which statement should you run?

  A. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);

  B. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);

  C. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);

  D. BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/ mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

  Correct Answer: B

  BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it's executed on secondary replicas. Copy-only backups don't impact the log chain or clear the differential bitmap. Incorrect Answers:

  A: Differential backups are not supported on secondary replicas. The software displays this error because the secondary replicas support copy-only database backups.

  Reference:

  https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/active-secondaries- backup-on-secondary-replicas-always-on-availability-groups

• Question 185:

  You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?

  A. automated

  B. interactive

  C. High Concurrency

  Correct Answer: A

  Azure Databricks makes a distinction between all-purpose clusters and job clusters. You use all-purpose clusters to analyze data collaboratively using interactive notebooks. You use job clusters to run fast and robust automated jobs.

  The Azure Databricks job scheduler creates a job cluster when you run a job on a new job cluster and terminates the cluster when the job is complete.

  Reference:

  https://docs.microsoft.com/en-us/azure/databricks/clusters

• Question 186:

  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: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  This is the correct solution as you can't overwrite an existing Azure SQL Database database during restore.

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups#geo-restore https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups

• Question 187:

  Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

  A. Business Critical 4-vCore

  B. Hyperscale

  C. General Purpose v-vCore

  D. Serverless

  Correct Answer: A

  There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed. Incorrect Answers:

  B: Hyperscale is for large databases

  Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

• Question 188:

  Which audit log destination should you use to meet the monitoring requirements?

  A. Azure Storage

  B. Azure Event Hubs

  C. Azure Log Analytics

  Correct Answer: C

  Scenario: Use a single dashboard to review security and audit data for all the PaaS databases.

  With dashboards can bring together operational data that is most important to IT across all your Azure resources, including telemetry from Azure Log Analytics.

  Note: Auditing for Azure SQL Database and Azure Synapse Analytics tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs.

  Reference:

  https://docs.microsoft.com/en-us/azure/azure-monitor/visualize/tutorial-logs-dashboards

• Question 189:

  What should you implement to meet the disaster recovery requirements for the PaaS solution?

  A. Availability Zones

  B. failover groups

  C. Always On availability groups

  D. geo-replication

  Correct Answer: B

  Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.

  The auto-failover groups feature allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active georeplication feature, designed to simplify deployment and management of geo-replicated databases at scale. You can initiate failover manually or you can delegate it to the Azure service based on a user-defined policy.

  The latter option allows you to automatically recover multiple related databases in a secondary region after a catastrophic failure or other unplanned event that results in full or partial loss of the SQL Database or SQL Managed Instance

  availability in the primary region.

  Reference:

  https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview

• Question 190:

  What should you use to migrate the PostgreSQL database?

  A. Azure Data Box

  B. AzCopy

  C. Azure Database Migration Service

  D. Azure Site Recovery

  Correct Answer: C

  Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview