Master Microsoft DP-900 Exam with Reliable Practice Questions
Upgrade to Premium
You have data saved in the following format:
Which format was used?
Correct : B
Start a Discussions
You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?
Correct : A
Start a Discussions
What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
Correct : A, C, F
Start a Discussions
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?
Correct : 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.
Start a Discussions
Which Azure SQL offering provides near-IOO percent compatibility with on-premises Microsoft SQL Server instances, while providing automated updates,
backups, and maintenance tasks?
Correct : A
Start a Discussions