QUESTION: 65

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?

durability
isolation
atomicity
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

Reveal Solution Next Question

QUESTION: 66

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

INSERT
ALTER
DROP
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

Reveal Solution Next Question

QUESTION: 67

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?

INSERT
MERGE
UPDATE
CREATE

Answer(s): C

Reference:

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

Reveal Solution Next Question

QUESTION: 68

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

Azure HDInsight
Azure SQL Database
Azure Cosmos DB
SQL Server on Azure Virtual Machines

Answer(s): B

Reference:

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

Reveal Solution Next Question

Free DP-900 Exam Braindumps (page: 18)

QUESTION: 65

Explanation:

Reference:

QUESTION: 66

Explanation:

Reference:

QUESTION: 67

Reference:

QUESTION: 68

Reference:

DP-900 Discussions & Posts