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: 22)

Page 21 of 72
PDF with 306 Questions

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

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Reference:

https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/ https://azure.microsoft.com/en-us/services/sql-database/#product-overview



Which statement is an example of Data Definition Language (DDL)?

  1. SELECT
  2. JOIN
  3. UPDATE
  4. CREATE

Answer(s): D

Explanation:

Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
-ALTER
-Collations
-CREATE
-DROP
-DISABLE TRIGGER
-ENABLE TRIGGER
-RENAME
-UPDATE STATISTICS
-TRUNCATE TABLE
-INSERT


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/statements



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

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Yes
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases.

Box 2: No
SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks.
Instead use Azure Data Studio to create SQL notebook.

Box 3: Yes
You can use the Azure Data Studio to restore databases.


Reference:

https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio



You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?

  1. Azure Cosmos DB
  2. Azure HDInsight
  3. Azure SQL Database
  4. Azure Synapse Analytics

Answer(s): C

Explanation:

Azure SQL Database is relational database and a managed service.
Incorrect Answers:
A, B: Cosmos DB, HDInsight are non-relational databases.
D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing


Reference:

https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment






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

DP-900 Discussions & Posts