Design and Implement Database Objects DP-800 Practice Questions (Page 8)

Questions 36–40

1. 36foundation · easy

   Which clause is used to define a DEFAULT constraint when creating a table?

   • ADEFAULT
   • BIDENTITY
   • CCONSTRAINT
   • DCHECK
   Reveal Solution Discussion Select an answer first
2. 37application · medium

   A financial institution must store transaction records in a way that is tamper-evident and provides cryptographic proof of integrity. The database is Azure SQL Database. You need to implement a solution that meets this requirement with minimal application changes. What should you implement?

   • ACreate a temporal table to keep a history of changes.
   • BCreate a ledger table for the transaction records and use the ledger view to verify the integrity of the data.
   • CCreate a regular table and enable change data capture (CDC) to track changes.
   • DCreate a regular table and add a CHECKSUM column that is updated by a trigger.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   What is a limitation of indexing a JSON column directly?

   • AIndexes on JSON columns are automatically created
   • BJSON columns cannot be indexed at all
   • CYou cannot create a regular index directly on a JSON column
   • DJSON columns must be indexed with a columnstore index
   Reveal Solution Discussion Select an answer first
5. 39foundation · easy

   What is the purpose of a CHECK constraint?

   • ATo create an index on a column
   • BTo automatically generate values for a column
   • CTo enforce domain integrity by limiting the values that can be stored in a column
   • DTo enforce uniqueness of column values
   Reveal Solution Discussion Select an answer first
6. 40expert · hard

   A bank needs to track changes to account balances for regulatory audits. They must be able to query the balance as of any point in time. The Accounts table has a PRIMARY KEY on AccountID and a FOREIGN KEY to Customers. You need to implement this with minimal impact on existing queries that do not specify a time. What should you do?

   • AAdd SYSTEM_VERSIONING to the Accounts table to create a temporal table.
   • BAdd ValidFrom and ValidTo columns and update them in application code.
   • CCreate a view that joins the Accounts table with a nightly snapshot table.
   • DCreate a separate AccountHistory table and a trigger to populate it.
   Reveal Solution Discussion Select an answer first