Microsoft
DP-300 · Question #246
Hotspot Question You have an Azure SQL logical server. You run the following script. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct
Sign in or unlock DP-300 to reveal the answer and full explanation for question #246. The question stem and answer options stay visible for context.
Submitted by mateo_ar· Mar 6, 2026Implement a secure environment / Configure database authentication and authorization - specifically understanding Azure SQL Ledger features for data integrity and tamper-evidence (DP-300 / AZ-900 data security domain)
Question
Hotspot Question You have an Azure SQL logical server. You run the following script. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer:
Exhibits
Answer Area
- The Orders table will allow only rows to be inserted.
- To create additional tables in the Sales database, the
LEDGER = ONparameter must be used. - To ensure that a timestamp is added to each row in the Orders table, the
GENERATED ALWAYScolumn must be added to the script.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure SQL Ledger#Ledger Tables#Database Security#Append-Only vs Updatable Ledger