Exam DP-300 topic 2 question 34 discussion

Actual exam question from Microsoft's DP-300

Question #: 34
Topic #: 2

HOTSPOT -

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.

Show Suggested Answer

Suggested Answer:

by Metarineo at Jan. 24, 2023, 1:33 p.m.

Comments

Submit Cancel

licna

Highly Voted 1 year, 9 months ago

I think it's NO - as we are creating so called updatable ledger table (i.e. not append-only) , we can also delete and update rows. NO - the CREATE DATABASE statement does not contain "WITH LEDGER = ON" clause thus it can contain non-ledger tables NO - when the GENERATED ALWAYS columns are not specified in the CREATE statement they'll be created automatically

upvoted 11 times

yyc585

10 months ago

CREATE DATABASE Database01 ( EDITION = 'GeneralPurpose', SERVICE_OBJECTIVE='GP_Gen5_2', MAXSIZE = 2 GB ) WITH LEDGER = ON; GO https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-how-to-configure-ledger-database?view=sql-server-ver16&tabs=t-sql%2Ct-sql2&pivots=as1-azure-sql-database

upvoted 2 times

...

amazonalex

Highly Voted 1 year, 6 months ago

I think answer is NNN:If any of the required generated always columns isn't defined in the CREATE TABLE statement and the statement includes LEDGER = ON, the system will automatically attempt to add the column... https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver16#generate-always-columns

upvoted 5 times

...