A financial services company must store transaction records in a way that detects any tampering by database administrators. The solution must enforce that transaction amounts are positive and that each transaction has a unique identifier. Which table design should you use?

A regular table with a UNIQUE constraint on TransactionID and a DEFAULT constraint for Amount.

An external table referencing a CSV file with a CHECK constraint.

A temporal table with a PRIMARY KEY and a CHECK constraint for Amount > 0.

A ledger table with a PRIMARY KEY on TransactionID and a CHECK constraint for Amount > 0.

In a graph database, what does an edge table represent?

The relationship between two nodes

The entities or objects in the graph

What does it mean for an index to be 'aligned' with a partitioned table?

The index is rebuilt whenever the table is partitioned

The index uses the same partition function and scheme as the table

The index has the same name as the table

The index is stored in the same filegroup as the table

What is the primary purpose of a system-versioned temporal table?

To replicate data to another server

To automatically track the history of data changes with valid time periods

What is the purpose of a DEFAULT constraint?

To ensure column values are unique

To create an index on the column

To provide a value for a column when no value is specified during insert

To validate that column values meet a condition

Microsoft Certified:SQL AI Developer Associate

Domain 1Objective 1

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

Part of the Design and develop database solutions domain, which accounts for 35–40% of the DP-800 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~18–32 in this domain), expect 5–8 from this objective — we provide 47 practice questions to prepare you well beyond it. (estimate)

47questions here

10free pages

17concepts

35–40%of the exam

Questions 1–5

1application · medium
A financial services company must store transaction records in a way that detects any tampering by database administrators. The solution must enforce that transaction amounts are positive and that each transaction has a unique identifier. Which table design should you use?
Select an answer first
2foundation · easy
In a graph database, what does an edge table represent?
Select an answer first
3foundation · easy
What does it mean for an index to be 'aligned' with a partitioned table?
Select an answer first
4foundation · easy
What is the primary purpose of a system-versioned temporal table?
Select an answer first
5foundation · easy
What is the purpose of a DEFAULT constraint?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-800

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-800” is a trademark of its owner, used for identification only.