Which Azure Cosmos DB API should you use for a graph database?
Answer : A
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
What is a characteristic of non-relational data?
Answer : D
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
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.
What is used to define a query in a stream processing jobs in Azure Stream Analytics?
Answer : D
Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
Answer : B