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

Page 16 of 78
PDF with 306 Questions

HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

  1. INSERT
  2. MERGE
  3. UPDATE
  4. CREATE

Answer(s): C


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15



Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?

  1. Azure HDInsight
  2. Azure SQL Database
  3. Azure Cosmos DB
  4. SQL Server on Azure Virtual Machines

Answer(s): B


Reference:

https://azure.microsoft.com/en-us/services/sql-database/#features



You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.
You need to embed documents and query results into a SQL notebook.
What should you use?

  1. Microsoft SQL Server Management Studio (SSMS)
  2. Azure Data Studio
  3. Azure CLI
  4. Azure PowerShell

Answer(s): B


Reference:

https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/






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

DP-900 Exam Discussions & Posts