Microsoft DP-900 Microsoft Azure Data Fundamentals Exam Practice Test

Page: 1 / 14
Total 292 questions
Question 1

Which Azure Cosmos DB API should you use for a graph database?



Answer : A


Question 2

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?



Answer : B


Question 3

What is a characteristic of non-relational data?



Answer : D


Question 4

Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,

backups, and maintenance tasks?



Answer : A


Question 5

A bank has a system that manages financial transactions.

When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

Of which ACID semantic is this an example?



Answer : B

Isolation. See course material:

o concurrent transactions cannot interfere with one another, and must result in a consistent database state.

o For example, while the transaction to transfer funds from one account to another is in-process, another transaction that checks the balance of these accounts must return consistent results - the balance-checking transaction can't retrieve a value for one account that reflects the balance before the transfer, and a value for the other account that reflects the balance after the transfer.


Question 6

What is used to define a query in a stream processing jobs in Azure Stream Analytics?



Answer : D


Question 7

Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?



Answer : B


Page:    1 / 14   
Total 292 questions