Topic: DP-600 topic 1 question 85

You have a Fabric tenant that contains a warehouse.

You are designing a star schema model that will contain a customer dimension. The customer dimension table will be a Type 2 slowly changing dimension (SCD).

You need to recommend which columns to add to the table. The columns must NOT already exist in the source.

Which three types of columns should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

A.
a foreign key
B.
a natural key
C.
an effective end date and time
D.
a surrogate key
E.
an effective start date and time

  • vish9
  • New member
  • Offline

Re: DP-600 topic 1 question 85

As per chat GPT: Surrogate keys are typically used in dimension tables rather than fact tables. In a data warehouse, a surrogate key is a unique identifier assigned to each record in a dimension table, usually for internal processing and joining purposes. It provides a stable reference to the dimension record, regardless of any changes in the natural key or other attributes.

Re: DP-600 topic 1 question 85

B: A natural key would be the Dim tables own Primarykey column not the source Primary key
C & D: is requires to incorporate SCD Type 2.

Re: DP-600 topic 1 question 85

Sorry there is a type in my comment above it should read C&E
so the correct answer is BC&E

Re: DP-600 topic 1 question 85

Let's discard,

A. A FOREIGN KEY in SQL is a key (a column field) that is used to relate two tables. The FOREIGN KEY field is related or linked to the PRIMARY KEY of another database table.
It already exists at the origin.
B. Natural key, likewise, already exists in the origin.

CDE, are the fields that we must create in our ETL to create an SCD2.

Re: DP-600 topic 1 question 85

Surrogate key is used in Fact Tables not Dim Tables