QUESTION: 101

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.

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

Answer(s): B,C,E

Explanation:

Incorrect Answers:
A, D: Resource group permissions is not required to query an Azure SQL database table.

Reference:

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

Reveal Solution Next Question

QUESTION: 102

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

SET
VALUES
KEY
JOIN

Answer(s): D

Reference:

https://www.tutorialspoint.com/sql/sql-using-joins.htm

Reveal Solution Next Question

QUESTION: 103

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?

Azure Application Gateway
Azure Traffic Manager
Azure DNS
Azure Private Link

Answer(s): D

Explanation:

Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary

Reference:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

Reveal Solution Next Question

QUESTION: 104

DRAG DROP (Drag and Drop is not supported)
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:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: Azure SQL Database single database
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns.
Scenarios well suited for serverless compute
Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time.
Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service.
New single databases without usage history where compute sizing is difficult or not possible to estimate prior to deployment in SQL Database.

Box 2: Azure SQL Managed Instance
Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service.

Box 3: Azure SQL Database elastic pool
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

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

Reveal Solution Next Question

Free DP-900 Exam Braindumps (page: 26)

QUESTION: 101

Explanation:

Reference:

QUESTION: 102

Reference:

QUESTION: 103

Explanation:

Reference:

QUESTION: 104

Explanation:

Reference: