DP-300 Certification Practice Question #96

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.

Accepted Answer

Statement 1 (No): `LEDGER = ON` without `APPEND_ONLY = ON` creates an *updatable* ledger table — INSERTs, UPDATEs, and DELETEs are all allowed (history tracked in ledger). Statement 2 (No): The `CREATE DATABASE Sales` has no `WITH LEDGER = ON` clause, so non-ledger tables can be created freely. Statement 3 (No): SQL Server/Azure SQL automatically adds the required `GENERATED ALWAYS` hidden columns when `LEDGER = ON` is specified — manual addition is not required.

More DP-300 practice questions