Microsoft DP900 Exam Dumps|QAs Page -20

Last updated on July 14th, 2024 at 12:07 am

Microsoft DP900 Exam Dumps post contains real and latest questions for Microsoft Azure Fundamentals.

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 96-100

Q96. DRAG DROP –
Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match its worth one point.
Select and Place:

dp_900 question 96
Correct Answer
dp_900 answer 96

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

Q97. Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

  1. SET
  2. VALUES
  3. KEY
  4. JOIN
Correct Answer

4. JOIN

Q98. You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  1. You must be assigned the Reader role for the resource group that contains the database.
  2. You must have SELECT access to the Products table.
  3. You must have a user in the database.
  4. You must be assigned the Contributor role for the resource group that contains the database.
  5. Your IP address must be allowed to connect to the database.
Correct Answer

2. You must have SELECT access to the Products table.
3. You must have a user in the database.
5. Your IP address must be allowed to connect to the database.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

Q99. DRAG DROP –
Match the security components to the appropriate scenarios.
To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

dp_900 question 99
Correct Answer
dp_900 answer 99

Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure

Q100. You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?

  1. You need to generate reports without affecting the transactional workload.
  2. You need to audit the transactional application.
  3. You need to implement high availability in the event of a regional outage.
  4. You need to improve the recovery point objective (RPO).
Correct Answer

1. You need to generate reports without affecting the transactional workload.

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

Scroll to Top