Administering Microsoft Azure SQL Solutions practice questions

1. Question 1 of 25

   Select 3

   You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • Atotal size of all the databases
   • Bgeo-replication support
   • Cnumber of concurrently peaking databases * peak CPU utilization per database
   • Dmaximum number of concurrent sessions for all the databases
   • Etotal number of databases * average CPU utilization per database

   Show answer

   Correct answer: A, C, E

   How others answered

   • ACE100%

   Explanation

   D is not correct. The database sessions are not mentioned anywhere in the documentation for elastic pool cost-effectiveness calculations. Each database counts as one. The number of sessions within the databases doesn't matter.

   Adapted from community discussion by pozdrotechno · 2022-03-12 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • azure.microsoft.com documentation
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 1 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. N

      Nityaanantha_Raman

      2025-03-22

      Selected A, C, E10 upvotes

      answer is correct https://docs.google.com/document/d/1oNH9i2ssNi9gISG3JGuxUoUhmAA4xCaGahEKv2dRN6Y/edit?usp=sharing

   2. M

      Mladen_66

      2021-09-01

      4 upvotes

      ACE for the vCore - https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

   3. M

      MS_KoolaidMan

      2024-09-26

      Selected A, C, E2 upvotes

      The given answer is correct based on the Microsoft Learn documentation. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql#how-do-i-choose-the-correct-pool-size

   4. P

      pozdrotechno

      2022-03-12

      2 upvotes

      D is not correct. The database sessions are not mentioned anywhere in the documentation for elastic pool cost-effectiveness calculations. Each database counts as one. The number of sessions within the databases doesn't matter.

2. Question 2 of 25

   You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead. What should you do?

   • AFrom the Azure portal, set a mask on the Email column.
   • BFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
   • CFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.
   • DFrom Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

   Show answer

   Correct answer: A

   How others answered

   • A89%

   Explanation

   Yep A You set up a dynamic data masking policy in the Azure portal by selecting the Dynamic Data Masking blade under Security in your SQL Database configuration pane. This feature cannot be set using portal for SQL Managed Instance. For more information, see Dynamic Data Masking. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

   Adapted from community discussion by jerkyflexoff · 2022-11-04 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 2 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. J

      jerkyflexoff

      2022-11-04

      7 upvotes

      Yep A You set up a dynamic data masking policy in the Azure portal by selecting the Dynamic Data Masking blade under Security in your SQL Database configuration pane. This feature cannot be set using portal for SQL Managed Instance. For more information, see Dynamic Data Masking. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

   2. S

      Socket

      2024-08-03

      Selected A1 upvote

      The correct option is A. From the Azure portal, set a mask on the Email column. By setting a mask on the Email column, you can control the way sensitive data is displayed to non-administrative users. The mask allows you to show a modified version of the data while keeping the original data secure. In this case, you can configure the mask to display the email addresses in the format of [email protected] as required. Option B, setting a sensitivity classification of Confidential for the Email column, is not the most appropriate choice for this scenario. While sensitivity classifications can be used to label data and apply policies, they do not directly handle the masking of data for display purposes. Options C and D, setting an email mask from Microsoft SQL Server Management Studio or granting SELECT permission to users for all columns except Email, are not correct because they both involve implementing security measures at the database level, but they do not specifically address the data masking requirement for displaying the email addresses in the desired format.

   3. O

      ofzrgrz

      2024-08-29

      4 upvotes

      This is a DP-203 question. Azure Synapse Analytics is not part of the DP-300 curriculum.

   4. F

      Fer079

      2024-01-12

      2 upvotes

      A and B can both work, however, I would select C since A doesn't describe the type of mask. It needs to be email mask on the email column. If you apply dynamic data from Azure portal, and you don´t specify the type of mask, it will detect the type of the column to apply the mask, so in this case, it applies the default mask for a column type as varchar therefore it is not applying an email mask type

3. Question 3 of 25

   You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: ✑ 24 cores ✑ 500 GB of storage ✑ 124 GB of memory ✑ More than 50,000 IOPS During periods of off-peak usage, the service tier of Azure SQL Database will be set to Standard. Which service tier should you use during peak usage?

   • ABusiness Critical
   • BPremium
   • CHyperscale

   Show answer

   Correct answer: A

   How others answered

   • A67%
   • B33%

   Only 67% agreed on this answer — treat it as contested rather than settled.

   Explanation

   I believe that correct answer is A (Business critical in vCore purchasing model) because we have request to scale up and down not only in compute resources but also a storage which is available only vCore purchasing model. Hyperscale is not suits us well as well because it is reversable only within 45 days of the original migration to Hyperscale. Links https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql and https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

   Adapted from community discussion by rctm_bm · 2022-09-10 · 6 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 3 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. O

      ofzrgrz

      2023-08-29

      13 upvotes

      This is a question for DP-300 👍 I hope we're good for the next questions now lol

   2. U

      U_C

      2021-12-30

      9 upvotes

      I think the answer should be Premium which is in the DTU Purchase Model with "Standard". Business Critical is with General Purpose in vCore Purchase Model.

   3. R

      rctm_bm

      2022-09-10

      6 upvotes

      I believe that correct answer is A (Business critical in vCore purchasing model) because we have request to scale up and down not only in compute resources but also a storage which is available only vCore purchasing model. Hyperscale is not suits us well as well because it is reversable only within 45 days of the original migration to Hyperscale. Links https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql and https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

   4. B

      bsk1983

      2023-08-31

      Selected A3 upvotes

      Answer is business Critical. Requirements in question has specific CPU, memory and Storage during peak season and the ONLY option that meets this requirement is Vcore purchasing model --> "Business Critical Service Tier". I know question says Azure database will be switched to "Standard tier" (DTU purchasing model) during OFF peak season. Its easy to swap between V core and DTU purchasing models without any downtime to Azure sql database, which meets requirements and makes the service tier change easy between Peak and OFF peak seasons. I Strongly agree the answer is "Business Critical". REASON I say "Premium" CANNOT be answer is because it is part of DTU purchasing model which makes it challenging to accommodate the requirement of specific CPU, memory and storage need during peak season because DTU model comes with resources that can be adjusted with predefined configuration which DOESNOT meet asked requirements in the question about CPU, RAM and Storage

4. Question 4 of 25

   You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?

   • AAlways On availability groups
   • BBackup and Restore
   • Clog shipping
   • DDatabase Migration Assistant

   Show answer

   Correct answer: B

   How others answered

   • B92%

   Explanation

   DMA does not support database migrations to Azure SQL Managed Instance. Recommendation is to use the Azure SQL migration extension for Azure Data Studio, which supports both online and offline database migrations to Azure SQL Managed Instance, but here we don´t have the option "Azure SQL migration extension for Azure Data Studio". https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16#capabilities Regarding log shipping to Managed Instance is not possible; it only supports the restore of full backups. https://dba.stackexchange.com/questions/232332/is-it-possible-to-log-ship-from-on-premise-sql-server-to-azure-sql-managed-insta So the only option that we can use is Backup and Restore

   Adapted from community discussion by Fer079 · 2023-01-10 · 13 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 4 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. F

      Fer079

      2023-01-10

      Selected B13 upvotes

      DMA does not support database migrations to Azure SQL Managed Instance. Recommendation is to use the Azure SQL migration extension for Azure Data Studio, which supports both online and offline database migrations to Azure SQL Managed Instance, but here we don´t have the option "Azure SQL migration extension for Azure Data Studio". https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16#capabilities Regarding log shipping to Managed Instance is not possible; it only supports the restore of full backups. https://dba.stackexchange.com/questions/232332/is-it-possible-to-log-ship-from-on-premise-sql-server-to-azure-sql-managed-insta So the only option that we can use is Backup and Restore

   2. S

      sca88

      2024-04-22

      3 upvotes

      Sorry, my bad, but the Microsoft documentation is misleading. It says: "The Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality when you: upgrade to a new version of SQL Server migrate to Azure SQL Database migrate to Azure SQL Managed Instance" but below there is an alert "DMA does not support database migrations to Azure SQL Managed Instance. Use the Azure SQL migration extension for Azure Data Studio instead, which supports both online and offline database migrations to Azure SQL Managed Instance." So I suppose the only possible answer is B

   3. L

      licna

      2023-01-09

      2 upvotes

      I am not sure about the DMA. This tool is meant to be used to assess only when it comes to migration to Managed Instance, see https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide?view=azuresql For actual migration DMS should be used, see e.g. https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide. So from the options available I'd be tempted to choose Log Shipping. It's close to Transactional Log Replication which is one of the recommended method, although I know it's not ideal if it comes to latency. So I suggest to read the question and answers carefully to distinguish between DMA and DMS. If the later one is among answers then this should be correct.

   4. L

      lziolkow

      2023-12-14

      3 upvotes

      Answer A: Always On availability groups. Why? The clue is: "The solution must minimize downtime and prevent data loss." For reference see: https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-overview?view=azuresql#compare-migration-options Migration option: Link feature for Azure SQL Managed Instance

5. Question 5 of 25

   You have an Azure subscription linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances. You need to ensure that you can manage the SQL Server instances by using a single user account. What should you do first?

   • AEnable a user-assigned managed identity on each virtual machine.
   • BDeploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain.
   • CEnable a system-assigned managed identity on each virtual machine.
   • DJoin the virtual machines to the Azure AD tenant.

   Show answer

   Correct answer: B

   How others answered

   • B60%
   • A40%

   Only 60% agreed on this answer — treat it as contested rather than settled.

   Explanation

   According to the article below we can use managed identity on azure vm only on SQL Server 2022. In the question is 2019, so the answer is B. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/configure-azure-ad-authentication-for-sql-vm?view=azuresql&tabs=azure-portal

   Adapted from community discussion by Adamus2077 · 2023-08-11 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 5 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. V

      Vergee

      2024-01-12

      Selected B2 upvotes

      To manage SQL Server instances on multiple Azure virtual machines using a single user account, you should first deploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain (Option B)12. Azure Active Directory Domain Services provides managed domain services such as domain join, group policy, LDAP, and Kerberos/NTLM authentication. By joining the virtual machines to the Azure AD DS domain, you can centralize the management of user accounts, which simplifies the process of managing SQL Server instances across multiple virtual machines.

   2. B

      bakamon

      2023-05-30

      Selected B1 upvote

      deploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain . This will allow you to use a single domain user account to manage the SQL Server instances on all of the virtual machines. a user-assigned managed identity can be associated with more than one Azure resource. However, in this scenario, the goal is to manage the SQL Server instances using a single user account. While using a user-assigned managed identity would allow you to authenticate to Azure resources using a single identity, it would not provide a way to manage the SQL Server instances using a single user account.

   3. Y

      yyc585

      2024-01-06

      Selected B1 upvote

      Answer B. Enabling a user-assigned managed identity on each virtual machine is not required to solve the above scenario. User-assigned managed identities are used to authenticate to services that support Azure AD authentication, such as Azure Key Vault, without requiring the use of credentials in your code. Add Azure Active Directory User to Azure SQL Database. https://stackoverflow.com/questions/45044760/add-azure-active-directory-user-to-azure-sql-database. Add an existing Azure subscription to your tenant - Microsoft Entra .... https://learn.microsoft.com/en-us/entra/fundamentals/how-subscriptions-associated-directory.

   4. A

      Adamus2077

      2023-08-11

      Selected B2 upvotes

      According to the article below we can use managed identity on azure vm only on SQL Server 2022. In the question is 2019, so the answer is B. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/configure-azure-ad-authentication-for-sql-vm?view=azuresql&tabs=azure-portal

6. Question 6 of 25

   Select 3

   You have an Azure SQL Database elastic pool that contains 10 databases. You receive the following alert. Msg 1132, Level 16, state 1, Line 1 The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs. You need to resolve the alert. The solution must minimize administrative effort. Which three actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AIncrease the maximum storage of the elastic pool.
   • BDelete data from a database.
   • CRemove a database from the pool.
   • DEnable data compression.
   • EShrink individual databases.

   Show answer

   Correct answer: A, D, E

   How others answered

   • ADE43%
   • ACE36%
   • ACD21%

   Only 43% agreed on this answer — treat it as contested rather than settled.

   Explanation

   To resolve the storage limit alert for your Azure SQL Database elastic pool, you can: A. Increase the maximum storage limit of the elastic pool through Azure's management tools, which is a quick fix requiring minimal administrative effort. D. Enable data compression to reduce the storage size of tables and indexes, which can provide space savings without data loss. E. Shrink individual databases to release unused space back to the pool, although this should be done carefully to avoid performance issues due to fragmentation. Options B and C are less desirable as they involve deleting data or databases, which requires more effort and could impact your applications. Always consider the long-term implications and monitor storage after making changes to prevent future issues.

   Adapted from community discussion by [Removed] · 2023-11-06 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 6 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. [

      [Removed]

      2023-11-06

      5 upvotes

      To resolve the storage limit alert for your Azure SQL Database elastic pool, you can: A. Increase the maximum storage limit of the elastic pool through Azure's management tools, which is a quick fix requiring minimal administrative effort. D. Enable data compression to reduce the storage size of tables and indexes, which can provide space savings without data loss. E. Shrink individual databases to release unused space back to the pool, although this should be done carefully to avoid performance issues due to fragmentation. Options B and C are less desirable as they involve deleting data or databases, which requires more effort and could impact your applications. Always consider the long-term implications and monitor storage after making changes to prevent future issues.

   2. 2

      2f5c7cd

      2024-10-26

      Selected A, D, E2 upvotes

      https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql#elastic-pool-errors

   3. D

      Dalamain

      2024-04-11

      1 upvote

      Answer looks good - don't forget all these options could work but the question mentions the solutions must be the ones of "least administrative effort". For example option B Deleting data isn't as simple as it seems, you'd need to discover what data can be deleted, get permission from compliance teams on whether you can delete the "old/unused" data etc.

   4. D

      DaTheo

      2024-03-21

      1 upvote

      The answer D is wrong. For enable data compression, you need additional space. "The disk space requirements for enabling or disabling row or page compression are the same as for creating or rebuilding an index." https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver16

7. Question 7 of 25

   You have a Microsoft SQL Server 2017 server. You need to migrate the server to Azure. The solution must meet the following requirements: • Ensure that the latest version of SQL Server is used. • Support the SQL Server Agent service. • Minimize administrative effort. What should you use?

   • Aan Azure SQL Database elastic pool
   • BAzure SQL Database
   • CSQL Server on Azure Virtual Machines
   • DAzure SQL Managed Instance

   Show answer

   Correct answer: D

   How others answered

   • D100%

   Explanation

   Common solution from all 3 requirements is Azure SQL Managed Instance. Ensure that the latest version of SQL Server is used - Possible solutions - both MI and Azure SQL DB • Support the SQL Server Agent service - Possible solutions - both MI and VM • Minimize administrative effort - Possible solutions - both MI and Azure SQL DB

   Adapted from community discussion by yyc585 · 2024-01-06 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   View community discussion4

   Candidate context

   Question 7 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. Y

      yyc585

      2024-01-06

      Selected D5 upvotes

      Common solution from all 3 requirements is Azure SQL Managed Instance. Ensure that the latest version of SQL Server is used - Possible solutions - both MI and Azure SQL DB • Support the SQL Server Agent service - Possible solutions - both MI and VM • Minimize administrative effort - Possible solutions - both MI and Azure SQL DB

   2. [

      [Removed]

      2023-11-07

      3 upvotes

      D. Azure SQL Managed Instance Here's why this option fits your requirements: Ensure that the latest version of SQL Server is used: Azure SQL Managed Instance runs the latest stable version of SQL Server and is automatically updated, so you do not need to manually upgrade SQL Server. Support the SQL Server Agent service: Azure SQL Managed Instance supports SQL Server Agent, which allows you to schedule jobs and automate tasks just like you would in an on-premises SQL Server environment. Minimize administrative effort: Azure SQL Managed Instance provides a fully managed database service that reduces administrative overhead. It handles most of the management functions such as upgrading, patching, backups, and monitoring without user intervention.

   3. 0

      04db10c

      2024-06-03

      1 upvote

      Answer is C ( Chat GPT) To migrate your Microsoft SQL Server 2017 server to Azure while meeting the specified requirements, including ensuring the latest version of SQL Server is used, supporting the SQL Server Agent service, and minimizing administrative effort, you should use: C. SQL Server on Azure Virtual Machines Explanation: SQL Server on Azure Virtual Machines allows you to run SQL Server in a virtualized environment hosted in Azure, providing full control over the SQL Server instance, including the ability to install and manage SQL Server Agent service. With SQL Server on Azure Virtual Machines, you can choose the SQL Server version you want to deploy, ensuring that the latest version is used. This option provides the closest compatibility to an on-premises SQL Server environment while minimizing administrative effort compared to other options like managing individual databases in Azure SQL Database or Azure SQL Managed Instance. Therefore, the correct choice is option C. SQL Server on Azure Virtual Machines.

   4. W

      Woodcutter

      2023-07-14

      4 upvotes

      In my opinion, both VM and MI ensure the latest version and support Agent service. MI requires less administrative effort so it should be the correct answer. Correct me if I am wrong.

8. Question 8 of 25

   HOTSPOT - You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL server 2017 Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux. You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one-point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer

   Explanation

   Disregard my previous discussion, Answer that makes sense here is 1) Create a SQL 2019 AG on VM1 and then use 2) Distributed availability group for actual cutover/migration

   Adapted from community discussion by bsk1983 · 2023-09-05 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Answer figure

   

   View community discussion4

   Candidate context

   Question 8 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. B

      bsk1983

      2023-09-05

      12 upvotes

      Disregard my previous discussion, Answer that makes sense here is 1) Create a SQL 2019 AG on VM1 and then use 2) Distributed availability group for actual cutover/migration

   2. S

      sca88

      2024-04-10

      4 upvotes

      https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16 "A distributed Availability group is a special type of availability group that spans two separate availability groups. The availability groups that partecipate don't need to be in the same location. They can be phisical, virtual on-permises, in the public cloud or anywhere. This includes cross-domain and even cross-platform". So the answers will be 1. Create a SQL 2019 AG on VM1 2. Distributed availability group

   3. [

      [Removed]

      2023-11-07

      3 upvotes

      To prepare for the migration, you should upgrade the on-premises SQL servers to SQL Server 2019 and add a secondary replica to AG1. This will ensure that the on-premises servers are compatible with the SQL Server 2019 instance on VM1 and that AG1 can support cross-platform migration. To perform the migration, you should use a distributed availability group. This is a feature that allows you to create a distributed availability group that spans two availability groups, one on Windows and one on Linux. You can then perform a manual failover of the distributed availability group to VM1 and remove the on-premises replicas. This will minimize the downtime of DB1 during the migration.

   4. B

      bsk1983

      2023-08-31

      3 upvotes

      Add a secondary replica to Ag1 and Azure migrate are correct answers basing on sql version supportability in distributed AG in below url https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16

9. Question 9 of 25

   HOTSPOT - You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer

   Explanation

   Box 1: The server, the elastic pool, and the database Senario: SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. Litware technical requirements include: all SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality. Box 2: Azure Event hubs - Scenario: Migrate ManufacturingSQLDb1 to the Azure virtual machine platform. Event hubs are able to handle custom metrics. Incorrect Answers: Azure Log Analytics - Azure metric and log data are sent to Azure Monitor Logs, previously known as Azure Log Analytics, directly by Azure. Azure SQL Analytics is a cloud only monitoring solution supporting streaming of diagnostics telemetry for all of your Azure SQL databases. However, because Azure SQL Analytics does not use agents to connect to Azure Monitor, it does not support monitoring of SQL Server hosted on-premises or in virtual machines.

   Adapted from community discussion by OneplusOne · 2023-01-06 · 10 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

   Supporting references

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Answer figure

   

   View community discussion4

   Candidate context

   Question 9 discussion

   These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

   1. O

      OneplusOne

      2023-01-06

      10 upvotes

      A: Elastic pool and databases B: Log Analytics Streaming to log analytics is possible: https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql&tabs=azure-portal You can stream metrics and resource logs to a Log Analytics workspace in Azure Monitor. Data streamed here can be consumed by SQL Analytics (preview), which is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. Data streamed to a Log Analytics workspace can be analyzed with other monitoring data collected and also enables you to leverage other Azure Monitor features such as alerts and visualizations. https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql Collecting server metrics is not an option: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql

   2. Z

      Ziggybooboo

      2021-03-21

      7 upvotes

      Further to my previous comment the below is in the scenario: All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.

   3. A

      alain2

      2021-06-13

      6 upvotes

      IMO, collecting 'basic' metric from the Elastic pool and the database to a Log Analytics Workspace is enough to meet the tech requirements.

   4. U

      U_C

      2021-08-01

      4 upvotes

      Because you need to collect and stream data, it has to go the destination of Azure Event Hub.

10. Question 10 of 25

    Select 3

    You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • ATurn on auditing and write audit logs to an Azure Storage account.
    • BAdd extended properties to the column.
    • CTurn on auditing and write audit logs to an Event Hub
    • DApply sensitivity labels named Highly Confidential to the column.
    • ETurn on Azure Defender for SQL

    Show answer

    Correct answer: A, C, D

    How others answered

    • ACD45%
    • AD33%
    • ADE23%

    Only 45% agreed on this answer — treat it as contested rather than settled.

    Explanation

    To track each time values from a column are returned in a query, you can use the auditing feature in Azure SQL Database. Auditing allows you to track database events and write the audit logs to an Azure Storage account or an Event Hub. To store the audit logs for 365 days from the date the query was executed, you can configure the retention period for the audit logs to 365 days. Therefore, the correct answers are A, C, D. D is not so relevant in terms of retention but for filtering purpose it helps.

    Adapted from community discussion by yyc585 · 2024-01-06 · 2 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 10 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. I

       Itsalwaymethecap

       2022-07-09

       Selected A, C, D4 upvotes

       If you get option C as below instead of the one which is shown now - Turn on Advance Data Security for Azure SQL Server then the answers are ACD. At this moment its just AD

    2. Y

       yyc585

       2024-01-06

       Selected A, C, D2 upvotes

       To track each time values from a column are returned in a query, you can use the auditing feature in Azure SQL Database. Auditing allows you to track database events and write the audit logs to an Azure Storage account or an Event Hub. To store the audit logs for 365 days from the date the query was executed, you can configure the retention period for the audit logs to 365 days. Therefore, the correct answers are A, C, D. D is not so relevant in terms of retention but for filtering purpose it helps.

    3. O

       Oralinux

       2022-03-09

       3 upvotes

       Eventhub is streaming service and it's pub/sub, you should go with Azure Storage if you want to keep your logs for long time.

    4. J

       jerkyflexoff

       2021-11-03

       2 upvotes

       I am going to go ACD on this. Azure Defender? To configure writing audit logs to an event hub, select Event Hub. Select the event hub where logs will be written and then click Save. Be sure that the event hub is in the same region as your database and server. https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

11. Question 11 of 25

    You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?

    • Arow-level security
    • Bdata masking
    • CAlways Encrypted
    • Dcolumn-level security

    Show answer

    Correct answer: D

    How others answered

    • D75%
    • B25%

    Explanation

    inferring work is the key. With data-masking you cannot prevent to ask if a column is equal to a certain value. Also, the salespeople don't need any information of the credit card, maybe customer support would have a use of the masked credit card. So, column-level security is the solution.

    Adapted from community discussion by madab · 2022-02-25 · 16 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 11 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. M

       madab

       2022-02-25

       Selected D16 upvotes

       inferring work is the key. With data-masking you cannot prevent to ask if a column is equal to a certain value. Also, the salespeople don't need any information of the credit card, maybe customer support would have a use of the masked credit card. So, column-level security is the solution.

    2. Q

       quermi

       2021-11-09

       5 upvotes

       If you use Always encrypted, you must change the access to aplication because you need a certificate. Howeber if you use data mask only need alter column by example: ALTER TABLE Data.Membership ALTER COLUMN LastName varchar(100) MASKED WITH (FUNCTION = 'default()'); Then the salespeople see the data with masking, Only the administrartors o the user with UNMASK permision see the real data.

    3. C

       CaptainJameson

       2022-03-20

       4 upvotes

       To back this up, it is also mentioned by ms that data-masking will not prevent against inferring with an example: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15

    4. R

       rctm_bm

       2022-09-11

       Selected D1 upvote

       My vote goes to D. And here is why - data masking prevent unauthorized access of viewing data, but it "doesn't aim to prevent database users from connecting directly to the database and running exhaustive queries that expose pieces of the sensitive data" and we assume that in this question salespeople does have access to DB. So column-level security on my opinion is the best choice as it is allowing you to restrict column access to protect sensitive data even if you have access to DB. Links https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16 and https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security

12. Question 12 of 25

    Select 2

    You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • AImplement row-level security (RLS).
    • BCreate users in each database.
    • CConfigure the database firewall.
    • DConfigure the server firewall.
    • ECreate logins in the master database.
    • FImplement Always Encrypted.

    Show answer

    Correct answer: B, C

    How others answered

    • BC76%
    • BE24%

    Explanation

    The key is "only connect to and access their respective database", which means Contained DB's. In that case creating in each DB is the right choice.

    Adapted from community discussion by Mend · 2021-06-13 · 17 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 12 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. M

       Mend

       2021-06-13

       17 upvotes

       The key is "only connect to and access their respective database", which means Contained DB's. In that case creating in each DB is the right choice.

    2. G

       gerard

       2021-12-20

       13 upvotes

       DB is not the answer it means database in this case :-) the answer is BC

    3. M

       mbn

       2021-06-06

       7 upvotes

       incorrect; correct answer is BE: first create logins in the master database, then create users in each database https://docs.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage#create-accounts-for-non-administrator-users

    4. L

       learnazureportal

       2021-08-14

       6 upvotes

       You're incorrect. still Login can be created in the master database in PAAS. it is not excluded! The use case in this question is different. as long as we have to choose only two options so only selected orphan users (user without login).

13. Question 13 of 25

    You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query Store transitioning to a read-only state. What should you do?

    • ADouble the value of Data Flush interval
    • BDecrease by half the value of Data Flush Interval
    • CDouble the value of Statistics Collection Interval
    • DDecrease by half the value of Statistics Collection interval

    Show answer

    Correct answer: B

    How others answered

    • B59%
    • C41%

    Only 59% agreed on this answer — treat it as contested rather than settled.

    Explanation

    From my point of view, the correct answer is C. (Double the value of Statistics Collection Interval). To avoid Query Store transitioning to read-only state, the runtime statistics for the Last Stale Query Threshold days must fit in the defined Max Size (MB). If the Statistics Collection Interval is increased then less space will be used for the persisted runtime statistics and there will be more free space for new data. The Data Flush Interval can delay the transitioning to read-only state, but not minimize the possibility it occurs.

    Adapted from community discussion by miguelmol · 2021-10-04 · 33 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 13 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. M

       miguelmol

       2021-10-04

       33 upvotes

       From my point of view, the correct answer is C. (Double the value of Statistics Collection Interval). To avoid Query Store transitioning to read-only state, the runtime statistics for the Last Stale Query Threshold days must fit in the defined Max Size (MB). If the Statistics Collection Interval is increased then less space will be used for the persisted runtime statistics and there will be more free space for new data. The Data Flush Interval can delay the transitioning to read-only state, but not minimize the possibility it occurs.

    2. M

       matongax

       2022-10-28

       11 upvotes

       in microsoft prep test ,this question says B. Decrease Data Flush Interval.

    3. V

       vittOS

       2024-01-02

       Selected B5 upvotes

       https://learn.microsoft.com/en-us/sql/relational-databases/performance/manage-the-query-store?view=sql-server-ver16&tabs=ssms Stale Query Threshold (Days): Time-based cleanup policy that controls the retention period of persisted runtime statistics and inactive queries, expressed in days. By default, Query Store is configured to keep the data for 30 days, which might be unnecessarily long for your scenario. Avoid keeping historical data that you don't plan to use. This practice reduces changes to read-only status. The size of Query Store data and the time to detect and mitigate the issue will be more predictable. Use Management Studio or the following script to configure time-based cleanup policy: SQL Copy ALTER DATABASE [QueryStoreDB] SET QUERY_STORE (CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 90));

    4. T

       thedatadetective

       2023-01-25

       Selected B6 upvotes

       This clears up the confusion in MS documentation...it specifically states that Flush parameters are what controls Max DB store https://docs.microsoft.com/en-us/sql/relational-databases/performance/how-query-store-collects-data?view=sql-server-ver15#remarks

14. Question 14 of 25

    You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb by Azure SQL databases in sqlsrv1. What should you do?

    • ARun Query Store-based queries
    • BReview information provided by SQL Server Profiler-based traces
    • CReview information provided by Query Performance Insight
    • DRun dynamic management view-based queries

    Show answer

    Correct answer: D

    How others answered

    • D91%

    Explanation

    Just checked my Azure Database, "Query Performance Insight" only provides CPU, Data IO, Log IO, Duration, and Execution count information. Answer C is not correct.

    Adapted from community discussion by U_C · 2022-04-14 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 14 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. A

       a19003

       2022-03-17

       26 upvotes

       I believe D is right based on https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#identify-tempdb-performance-issues

    2. U

       U_C

       2022-04-14

       9 upvotes

       Just checked my Azure Database, "Query Performance Insight" only provides CPU, Data IO, Log IO, Duration, and Execution count information. Answer C is not correct.

    3. L

       learnazureportal

       2022-08-24

       6 upvotes

       This is the trick. "whether the performance issue relates to the use of tempdb"! therefore, we need to look at the trend. Option C is the right answer.

    4. A

       aks2304

       2023-02-06

       Selected D5 upvotes

       D is right based on https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#identify-tempdb-performance-issues

15. Question 15 of 25

    DRAG DROP - You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS. You need to configure storage for the virtual machine to support the database. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order. Select and Place:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer

    Explanation

    Follow these same steps to create striped virtual disk: ✑ Create Log Storage Pool. ✑ Create Virtual Disk ✑ Create Volume Box 1: a storage pool - Box 2: a virtual disk that uses stripe layout Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks. Box 3: a volume - Reference: https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/

    Adapted from community discussion by reachmymind · 2022-03-10 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Answer figure

    

    View community discussion4

    Candidate context

    Question 15 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. G

       guillermo

       2021-02-10

       21 upvotes

       Storage Layout options Simple, Mirror Or Partity. Create Virtual Disk with simple layout is correct.

    2. C

       cck21

       2021-04-09

       13 upvotes

       Answer given is correct. You can stripe 2 premium data disk to get 10000 IOPS. https://techcommunity.microsoft.com/t5/sql-server/optimize-oltp-performance-with-sql-server-on-azure-vm/ba-p/916794

    3. R

       reachmymind

       2022-03-10

       9 upvotes

       -> a storage pool -> a virtual disk that uses the simple layout -> a volume There are only three layouts while creating virtual disks on a storage pool: Simple - Data is striped across physical disks, maximizing capacity and throughput Mirror - Data is striped across physical disks, creating two or three copies of data Parity - Data and parity information is striped across physical disks, increasing reliability

    4. G

       gills

       2021-05-22

       7 upvotes

       This stripe is not about creating redundancy like RAID 5. This is about combining the total IOPS of the two virtual disk into a single volume with 10,000 IOPS. Redundancy is already provided by the Azure infrastructure hosting the virtual disk. It runs at 11 9s.

16. Question 16 of 25

    HOTSPOT - You have SQL Server on an Azure virtual machine that contains a database named Db1. You need to enable automatic tuning for Db1. How should you complete the statements? To answer, select the appropriate answer in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer

    Explanation

    Box 1: SET QUERY_STORE = ON (OPERATION MODE = READ_WRITE); Must enable the Query Store. Incorrect: If the server may be Azure SQL or Managed Instance then the response should be SET AUTOMATIC_TUNNIG=AUTO, but as it is a SQL server the Query store needs to be first enabled. Box 2: SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON) To configure individual automatic tuning options via T-SQL, connect to the database and execute the query such as this one: ALTER DATABASE current SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON) Setting the individual tuning option to ON will override any setting that database inherited and enable the tuning option. Setting it to OFF will also override any setting that database inherited and disable the tuning option. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

    Adapted from community discussion by [Removed] · 2022-02-02 · 32 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Answer figure

    

    View community discussion4

    Candidate context

    Question 16 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. T

       Tomi1234

       2022-01-10

       55 upvotes

       SET QUERY_STORE = ON (OPERATION_MODE = READ_WRITE); https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15 SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON ); https://docs.microsoft.com/en-us/sql/relational-databases/automatic-tuning/automatic-tuning?view=sql-server-ver15

    2. [

       [Removed]

       2022-02-02

       32 upvotes

       The right answer is as Tomi1234 say because is a VM SQL Server: Box1 - SET QUERY_STORE = ON (OPERATION MODE = READ_WRITE); Box2 - SET AUTOMATIC_TUNNING (FORCE_LAST_GOOD_PLAN = ON); https://www.sqlshack.com/understanding-automatic-tuning-in-sql-server-2017/ If the server may be Azure SQL or Managed Instance then the response should be: Box1. SET AUTOMATIC_TUNNIG=AUTO Box2. SET AUTOMATIC_TUNNING (FORCE_LAST_GOOD_PLAN = ON) and other options are SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON, CREATE_INDEX = ON, DROP_INDEX = OFF) https://docs.microsoft.com/es-es/azure/azure-sql/database/automatic-tuning-enable

    3. V

       vicky007_87

       2022-07-31

       5 upvotes

       Correct Answer: SET QUERY_STORE = ON (OPERATION MODE = READ_WRITE); SET AUTOMATIC_TUNING ( FORCE_LAST_GOOD_PLAN = ON ); Reason: As this is SQL Server hosted on Azure VM and not Azure SQL DB / MI, Query store needs to be first enabled and then automatic plan needs to be applied.

    4. C

       Colbrin

       2022-03-05

       5 upvotes

       The reference is wrong as it applies only to SQL Database and SQL managed instance. Tomi1234 provided the right answer

17. Question 17 of 25

    You have a version-8.0 Azure Database for MySQL database. You need to identify which database queries consume the most resources. Which tool should you use?

    • AQuery Store
    • BMetrics
    • CQuery Performance Insight
    • DAlerts

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for MySQL instance. Reference: https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store

    Adapted from community discussion by cck21 · 2021-04-09 · 9 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 17 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. C

       cck21

       2021-04-09

       9 upvotes

       Answer given is correct. Query performance insight in Azure Database for MySQL only cover long run query and wait statistics. https://docs.microsoft.com/en-us/azure/mysql/concepts-query-performance-insight

    2. J

       Jas_dandiwal

       2021-03-18

       6 upvotes

       my bad, answer A is correct as question relates to MYSQL. Query Performance Insight helps you to quickly identify what your longest running queries are, how they change over time, and what waits are affecting them.

    3. J

       JohnCrawford

       2021-01-07

       4 upvotes

       Query Performance Insight is based upon Query Store. Maybe that's why the suggested answer is Query Store? I was torn between the two choices. I think this is one of the questions where there is more than one correct answer. Since QPI is based on QS perhaps that's the rationale?

    4. C

       ChengKuo

       2020-12-19

       4 upvotes

       why not Query Performance Insight? - Query Performance Insight helps you to quickly identify what your longest running queries are, how they change over time, and what waits are affecting them. https://docs.microsoft.com/en-us/azure/mysql/concepts-query-performance-insight

18. Question 18 of 25

    You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once daily against each database by using Transact-SQL commands. What should you use to schedule the statement?

    • Aan Azure function
    • Ba SQL Server Agent Job
    • Can elastic job
    • DAzure Automation

    Show answer

    Correct answer: C

    How others answered

    • C100%

    Explanation

    the sad part is both Elastic Job and Azure Automation are valid responses (both can run T-SQL commands). I will go with Elastic Job for the sole reason that is free (as of 2023) and Azure Automation seems overkill for the task at hand - not only that, but it seems that it cannot reindex multiple DBs at once, for example. Proof that Azure Automation can also run reindex jobs: https://learn.microsoft.com/en-us/azure/automation/overview: "Common scenarios Azure Automation supports management throughout the lifecycle of your infrastructure and applications. Common scenarios include: Periodic maintenance - to execute tasks that need to be performed at set timed intervals like purging stale or old data, or reindex a SQL database"

    Adapted from community discussion by testdumps2017 · 2024-02-25 · 3 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 18 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. S

       SamBalbij

       2024-05-04

       7 upvotes

       An Azure SQL database has no associated SQL Agent, so this can't be correct

    2. T

       testdumps2017

       2024-02-25

       3 upvotes

       the sad part is both Elastic Job and Azure Automation are valid responses (both can run T-SQL commands). I will go with Elastic Job for the sole reason that is free (as of 2023) and Azure Automation seems overkill for the task at hand - not only that, but it seems that it cannot reindex multiple DBs at once, for example. Proof that Azure Automation can also run reindex jobs: https://learn.microsoft.com/en-us/azure/automation/overview: "Common scenarios Azure Automation supports management throughout the lifecycle of your infrastructure and applications. Common scenarios include: Periodic maintenance - to execute tasks that need to be performed at set timed intervals like purging stale or old data, or reindex a SQL database"

    3. V

       VikJo1978

       2024-05-01

       1 upvote

       The correct answer is (B). An SQL Server Agent job is the best option for these requirements. With an SQL Server Agent job, you can execute Transact-SQL statements regularly. An Azure Function is a good option if you want to create a custom solution. However, creating and managing an Azure Function can be more complex than an SQL Server Agent job. An Elastic Job is a good option if you need a solution for multiple Azure resources. However, creating and managing an Elastic Job can be more complex than an SQL Server Agent job. Azure Automation is a good option if you want to create a custom solution. However, creating and managing Azure Automation can be more complex than an SQL Server Agent job.

    4. A

       Adamus2077

       2024-02-15

       Selected C2 upvotes

       On Azure SQL Database elastic jobs is a replacement for SQL Server Agent. Elastic Jobs can do TSQL scheduled jobs. https://learn.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview?view=azuresql

19. Question 19 of 25

    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 SQL database named Sales. You need to implement disaster recovery for Sales to meet the following requirements: ✑ During normal operations, provide at least two readable copies of Sales. ✑ Ensure that Sales remains available if a datacenter fails. Solution: You deploy an Azure SQL database that uses the General Purpose service tier and failover groups. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Correct answer: B

    How others answered

    • B80%
    • A20%

    Explanation

    Answer is correct; though In the Premium and Business Critical service tiers, applications could have "read-only replicas" at no extra cost, but "read-only replicas " is disabled at cannot be enabled in Basic, Standard, or General Purpose service tiers ; https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

    Adapted from community discussion by ChengKuo · 2022-07-16 · 7 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 19 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. T

       themickou

       2022-08-11

       11 upvotes

       https://docs.microsoft.com/en-us/learn/modules/azure-sql-high-availability/7-higher-availablity-options you cannot have multiples replicas with auto failover and we need 2 here so NO

    2. C

       ChengKuo

       2022-07-16

       7 upvotes

       Answer is correct; though In the Premium and Business Critical service tiers, applications could have "read-only replicas" at no extra cost, but "read-only replicas " is disabled at cannot be enabled in Basic, Standard, or General Purpose service tiers ; https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

    3. V

       vicky007_87

       2022-07-31

       4 upvotes

       Answer: Yes Reason: Auto-Failover group if created for a General Purpose service tier will create a replica in another region which will provide protection against datacenter disaster and Auto-failover group also supports read-scale so we get two read replica (primary replica which is read/write and Auto-failover replica in another region which is read-only replica).

    4. C

       ChengKuo

       2022-07-20

       3 upvotes

       Did further search, general purpose tier can have 0 - 4 Read-only replicas using geo-replication which is auto configured by failover group, so the answer should be "YES"

20. Question 20 of 25

    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 Microsoft SQL Server Management Studio (SSMS), you rename Database1 on Server2 as Database2. From the Azure portal, you create a new database on Server2 by restoring the backup of Database1 from Server1, and then you delete Database2. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Correct answer: A

    How others answered

    • A100%

    Explanation

    This procedure is necessary and correct, as there is no option in Azure SQL Database to directly restore a database. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

    Adapted from community discussion by Jeembeem · 2021-03-29 · 20 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • azure.microsoft.com documentation
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 20 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. J

       Jeembeem

       2021-03-29

       20 upvotes

       It's "Yes": you can rename an Azure SQL Database on SSMS and then run the procedure. The explanation is wrong: there is no "replace" option on Azure SQL

    2. Q

       quermi

       2021-11-20

       2 upvotes

       When you rename a database you don't rename the database files on premise. I don't know if in Azure SQL database is the same if before is true, Then you can only restore wtith CREATE DATABASE Database2 AS COPY OF server1.Database1; it you meet two conditions: - When you rename database changes the name of database files - And Both servers' firewalls must be configured to allow inbound connection from the IP of the client issuing the T-SQL CREATE DATABASE ... AS COPY OF command. To determine the source IP address of current connection, execute SELECT client_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID https://www.mssqltips.com/sqlservertip/4419/renaming-physical-database-file-names-for-a-sql-server-database/ https://docs.microsoft.com/en-us/azure/azure-sql/database/database-copy?tabs=azure-powershell

    3. U

       U_C

       2021-04-04

       4 upvotes

       Answer is correct because you can NOT restore a backup from another server in Azure Database. But you can create a new DB by copying a backup from another server: -- Execute on the master database of the target server (server2) to start copying from Server1 to Server2 CREATE DATABASE Database2 AS COPY OF server1.Database1;

    4. A

       AmitB

       2021-08-14

       3 upvotes

       Answer is correct, It should be "NO" As asked in question, The solution must replace the existing Database1 on Server2. And in Solution: From Microsoft SQL Server Management Studio (SSMS), you rename Database1 on Server2 as Database2. From the Azure portal, you create a new database on Server2 by restoring the backup of Database1 from Server1, and then you delete Database2. When you perform the restore with replace, it will replace or overwrite the physical files as well but here by renaming database name will not change the physical files name.

21. Question 21 of 25

    HOTSPOT - You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to identify which deployment and resiliency options meet the following requirements: ✑ Support user-initiated backups. ✑ Support multiple automatically replicated instances across Azure regions. ✑ Minimize administrative effort to implement and maintain business continuity. What should you identify? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer

    Explanation

    Box 1: Azure SQL Managed Instance Managed Instance will support native BACKUP like SQL Server. COPY_ONLY Backup - Once you create a credential, you can backup any database using standard BACKUP T-SQL command: BACKUP DATABASE tpcc2501 - TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak' WITH COPY_ONLY - The only mandatory property is COPY_ONLY. Azure SQL Managed Instance owns the backup chain. This means that you cannot perform database backup that breaks the backup chain. Azure SQL Managed Instance allows you to perform only COPY_ONLY backups. Box 2: Auto-failover group - For geographic failover of instances of SQL Managed Instance, use Auto-failover groups. The auto-failover groups feature allows you to manage the replication and failover of some or all databases on a logical server to another region. Incorrect: Not Active geo-replication: Active geo-replication is not supported by Azure SQL Managed Instance. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-sql-db

    Adapted from community discussion by boopytoob · 2024-10-01 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Answer figure

    

    View community discussion4

    Candidate context

    Question 21 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. B

       boopytoob

       2024-10-01

       4 upvotes

       Azure SQL Managed Instance & Auto-failover group 1. Azure SQL Database single database does not support user-initiated backups: - https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql Therefore, the answer must be Azure SQL Managed Instance or SQL Server on Azure Virtual Machines. 2. Active geo-replication is only supported by Azure SQL Database - https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql Therefore, the answer must be either Auto-failover group or Zone-redundant deployment. 3. Zone-redundant deployment does not work across multiple Azure Regions - https://learn.microsoft.com/en-us/azure/storage/common/storage-redundancy Therefore, the answer must be Auto-failover group. 4. Auto-failover group is only supported by Azure SQL Managed Instance - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auto-failover-group-sql-mi?view=azuresql&tabs=azure-powershell Therefore, the answer must be Azure SQL Managed Instance & Auto-failover group.

    2. I

       Itsalwaymethecap

       2023-07-09

       4 upvotes

       The answers are: Azure SQL Managed Instance Auto-failover group The requirement is to have user initiated backup hence managed instance supports it. Since its managed instanced, Geo-replication is not supported hence auto-failover groups

    3. J

       jackdong

       2023-06-09

       4 upvotes

       I would go Azure SQL Managed Instance" and "Auto-failover group". "Active geo-replication" is applied for Azure SQL Database.

    4. T

       txustopo

       2023-06-13

       3 upvotes

       The correct Answers is "Azure SQL Databases" and "Geo-replication". "Minimize administrative effort to implement and maintain business continuity." is not in Virtual Machine and the question does not especify that type of Fail Over you want, but especify multiple replications.

22. Question 22 of 25

    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?

    • AYes
    • BNo

    Show answer

    Correct answer: B

    How others answered

    • B100%

    Explanation

    No. Azure SQL Database does not currently support cross server restore. The source and target server names must be the same. https://docs.microsoft.com/en-us/powershell/module/servicemanagement/azure.service/start-azuresqldatabaserestore?view=azuresmps-4.0.0

    Adapted from community discussion by Corbiz · 2021-02-22 · 4 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 22 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. M

       Meir

       2020-08-16

       20 upvotes

       The answer is yes. See https://docs.microsoft.com/en-us/powershell/module/az.sql/restore-azsqldatabase?view=azps-4.5.0 that doesn't have replsce option. The suggested solution is not for Azure DB

    2. [

       [Removed]

       2020-08-30

       5 upvotes

       "You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2." Based on the above statement, the above command will end up restoring backup of the deleted database again. So the answer is (B) No. ???

    3. J

       JohnCrawford

       2021-01-07

       4 upvotes

       The correct answer is YES. The Restore-AzSqlDatabase cmdlet restores a SQL database from a geo-redundant backup, a backup of a deleted database, a long term retention backup, or a point in time in a live database. The restored database is created as a new database. You can create an elastic SQL database by setting the ElasticPoolName parameter to an existing elastic pool.

    4. C

       Corbiz

       2021-02-23

       5 upvotes

       Sorry, answer is actually Yes. You can do it using the "-FromGeoBackup" parameter. Tested myself.

23. Question 23 of 25

    You need to recommend an availability strategy for an Azure SQL database. The strategy must meet the following requirements: ✑ Support failovers that do not require client applications to change their connection strings. ✑ Replicate the database to a secondary Azure region. ✑ Support failover to the secondary region. What should you include in the recommendation?

    • Afailover groups
    • Btransactional replication
    • CAvailability Zones
    • Dgeo-replication

    Show answer

    Correct answer: A

    How others answered

    • A86%

    Explanation

    In the question there is no demand for geo-replication. It might be that a is the answer since it supports region failover See https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell

    Adapted from community discussion by Meir · 2021-02-17 · 5 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • azure.microsoft.com documentation
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 23 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. W

       wyxh

       2021-02-23

       60 upvotes

       The answe should be A. Failover groups don't require changes on the connection string. Geo replica does.

    2. C

       Colbrin

       2021-03-05

       16 upvotes

       Yes, Geo-replication requires a change of connection string, can't be the right answer

    3. M

       Meir

       2021-02-17

       5 upvotes

       In the question there is no demand for geo-replication. It might be that a is the answer since it supports region failover See https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell

    4. N

       NJin

       2021-04-19

       5 upvotes

       Must be A. All other options require some sort of changes of application.

24. Question 24 of 25

    You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs. Which type of storage accounts should you use for the backups?

    • Alocally-redundant storage (LRS)
    • Bread-access geo-redundant storage (RA-GRS)
    • Czone-redundant storage (ZRS)
    • Dgeo-redundant storage (GRS)

    Show answer

    Correct answer: D

    How others answered

    • D60%
    • B40%

    Only 60% agreed on this answer — treat it as contested rather than settled.

    Explanation

    Geo-redundant storage (GRS) is cheaper compared to read-access geo-redundant storage (RA-GRS). Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. Data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. Incorrect Answers: A: Locally redundant storage (LRS) copies your data synchronously three times within a single physical location in the primary region. LRS is the least expensive replication option, but is not recommended for applications requiring high availability. B: RA-GRS is more expensive than GRS. Note: Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. When you enable read access to the secondary region, your data is available to be read if the primary region becomes unavailable. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS). C: Zone-redundant storage (ZRS) copies your data synchronously across three Azure availability zones in the primary region. Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy

    Adapted from community discussion by Luke97 · 2020-12-09 · 12 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 24 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. L

       Luke97

       2020-12-09

       12 upvotes

       According to Microsoft, "Geo-redundant storage (with GRS or GZRS) replicates your data to another physical location in the secondary region to protect against regional outages. However, that data is available to be read only if the customer or Microsoft initiates a failover from the primary to secondary region. When you enable read access to the secondary region, your data is available to be read at all times, including in a situation where the primary region becomes unavailable. For read access to the secondary region, enable read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS)." So, if Primary Region is unavailable and MS did not failover, then you can only restore Backup on secondary region if it is RA-GRS.

    2. U

       U_C

       2021-03-20

       8 upvotes

       The difference between GRS and RA-GRS: GRS - After failover, the read-only is available. If no failover, it can not be readable. RA-RGS - is always enable and read-only. If GRS is cheaper, D is the right answer.

    3. J

       Jas_dandiwal

       2021-03-04

       2 upvotes

       how come RA-GRS can be cheaper as this is a addon to provide access to data in secondary region even there is no outage in primary region. GRS should be cheaper as it replicates data and only accessible once primary region has an outage. Read the below from MS. With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS) In extreme circumstances where a region is lost due to a significant disaster, Microsoft may initiate a regional failover. In this case, no action on your part is required. Until the Microsoft-managed failover has completed, you won't have write access to your storage account. Your applications can read from the secondary region if your storage account is configured for RA-GRS or RA-GZRS.

    4. B

       bnc

       2021-01-25

       4 upvotes

       You can do the failover yourself on a GRS account, so technically GRS minimizes costs. That said, if you have a solution where all this DR is required, you'd almost certainly want RA-GRS for testing/verification. The cost difference is minimal (yes, the costs add up if you have tens of TBs of backups, but would represent only a very tiny percentage of the costs needed to run an app/db of this size). So again technically GRS but realistically you would select RA-GRS.

25. Question 25 of 25

    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 SQL database named Sales. You need to implement disaster recovery for Sales to meet the following requirements: ✑ During normal operations, provide at least two readable copies of Sales. ✑ Ensure that Sales remains available if a datacenter fails. Solution: You deploy an Azure SQL database that uses the General Purpose service tier and geo-replication. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Correct answer: A

    How others answered

    • A100%

    Explanation

    Looks like the answer here should be YES. While the failover isn't automatic, geo-replication does meet the stated requirements: Up to four secondaries are supported in the same or different regions, and the secondaries can also be used for read-only access queries. Ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

    Adapted from community discussion by BobbyTables · 2021-07-23 · 15 community upvotes. Third-party contribution; reviewed by our quality filter, not independently verified.

    Supporting references

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    View community discussion4

    Candidate context

    Question 25 discussion

    These are quality-filtered excerpts from third-party community discussion. They can be useful reasoning signals, but they are not official answers and have not been independently verified by DP-300 or CertExamHQ.

    1. B

       BobbyTables

       2021-07-23

       15 upvotes

       Looks like the answer here should be YES. While the failover isn't automatic, geo-replication does meet the stated requirements: Up to four secondaries are supported in the same or different regions, and the secondaries can also be used for read-only access queries. Ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

    2. C

       chigar

       2022-02-10

       3 upvotes

       The question and the provided answer might be outdated so here is an updated one: A - Yes. General Purpose allows for Failover without manual intervention ... As we discussed in an earlier module in this learning path, all of Azure SQL is built on Azure Service Fabric, which serves as the Azure backbone. If Azure Service Fabric determines that a failover needs to occur, the failover will be similar to that of a failover cluster instance (FCI). The service fabric will look for a node with spare capacity and spin up a new SQL Server instance. The database files will then be attached, recovery will be run, and gateways will be updated to point applications to the new node. No virtual network or listener or updates are required. This capability is built in. https://docs.microsoft.com/en-us/learn/modules/azure-sql-high-availability/4-high-availability-architecture Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center (region). https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview

    3. C

       CeyeN

       2021-12-29

       2 upvotes

       As part of High Availability architecture, each single database, elastic pool database, and managed instance in the Premium and Business Critical service tier is automatically provisioned with a primary read-write replica and several secondary read-only replicas. The secondary replicas are provisioned with the same compute size as the primary replica. The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and will not affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost. Answer is B https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

    4. R

       reachmymind

       2022-09-15

       Selected A3 upvotes

       YES https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out The High Availability architecture of Basic, Standard, and General Purpose service tiers does not include any replicas. The read scale-out feature is not available in these service tiers. However, geo-replicas can provide similar functionality in these service tiers.

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-300 practice, question 1 of 25