Free DP-900 Exam Braindumps (page: 18)

Page 17 of 72

A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?

  1. durability
  2. isolation
  3. atomicity
  4. consistency

Answer(s): A

Explanation:

Durability means that committed changes are permanent.

Incorrect:
Atomicity means that all transactions either succeed or fail completely.
Consistency guarantees relate to how a given state of the data is observed by simultaneous operations.
Isolation refers to how simultaneous operations potentially conflict with one another.


Reference:

https://learn.microsoft.com/en-us/azure/databricks/lakehouse/acid



Which statement is an example of Data Manipulation Language (DML)?

  1. INSERT
  2. ALTER
  3. DROP
  4. CREATE

Answer(s): A

Explanation:

DML events include INSERT, UPDATE, or DELETE statements.


Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/triggers/dml-triggers



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






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

DP-900 Discussions & Posts