CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Free DP-900 Exam Braindumps (page: 25)

Page 24 of 72
PDF with 306 Questions

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

Answer(s): B


Reference:

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



HOTSPOT (Drag and Drop is not supported)
To complete the sentence, select the appropriate option in the answer area.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server


Reference:

https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql



You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

  1. Microsoft SQL Server Data Tools (SSDT)
  2. Microsoft SQL Server Management Studio (SSMS)
  3. Azure Databricks
  4. Azure Data Studio

Answer(s): A


Reference:

https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15



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

  1. See Explanation section for answer.

Answer(s): A

Explanation:


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






Post your Comments and Discuss Microsoft DP-900 exam with other Community members:

DP-900 Discussions & Posts