Microsoft DP900 Exam Dumps|QAs Page -18

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

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

Microsoft DP900 Exam Dumps

Microsoft DP900 Exam Dumps – QAs 86-90

Q86. What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

  1. built-in high availability
  2. native support for cross-database queries and transactions
  3. system-initiated automatic backups
  4. support for encryption at rest
Correct Answer

2. native support for cross-database queries and transactions

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

Q87. A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?

  1. sqlcmd
  2. Microsoft SQL Server Management Studio (SSMS)
  3. Azure Data Studio
  4. Azure Data Explorer
Correct Answer

3. Azure Data Studio

Reference:
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Q88. You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?

  1. service principal authentication
  2. Azure Active Directory (Azure AD) authentication
  3. SQL authentication
  4. certificate authentication
Correct Answer

2. Azure Active Directory (Azure AD) authentication

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

Q89. HOTSPOT –
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

dp_900 question 89
Correct Answer
dp_900 answer 89

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

Q90. When you create an Azure SQL database, which account can always connect to the database?

  1. the Azure Active Directory (Azure AD) account that created the database
  2. the server admin login account of the logical server
  3. the Azure Active Directory (Azure AD) administrator account
  4. the sa account
Correct Answer

2. the server admin login account of the logical server

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

Scroll to Top