Cracking DP-203

1) What fields need to be added to the below table to make this a type 2 SCD?

Create table Audit

(

AuditId int,

AuditName varchar(10),

AuditSupervisorID char(4),

create_date datetime,

updated_date datetime

)

• A) Audit_id_sg int identity(1,1)

• B) is_active bit

• C) tracking_id int

• D) It is already an SCD Type 2

What is the ideal table size if you were to recommend a replicated table as the distribution strategy?

• A) < 0.5 GB

• B) < 1 GB

• C) < 2 GB

• D) < 5 GB

• E) < 10 GB

No other software except SQL Server is installed on an on-prem server. Which of the following file formats would you recommend to be used to pull data from a table in on-prem SQL Server to data lake storage using self hosted integration runtime?

• A) CSV

• B) ORC

• C) Parquet

What option should you enable in the source of dataflow transformation in ADF if you want to have the changes in schema flow through to the transformations.

• A) Allow Schema drift

• B) Infer Schema drift

• C) Propagate Schema

• D) Validate Schema

Synapse SQL pools use Apache Spark architecture for distributed processing.

• A) True

• B) False