You need to implement a Type 3 slowly changing dimension (SCD) for product category data in an Azure Synapse Analytics dedicated SQL pool. You have a table that was created by using the following…

Question

Exhibit

Options

• A[EffectiveStartDate] [datetime] NOT NULL,
• B[CurrentProductCategory] [nvarchar] (100) NOT NULL,
• C[EffectiveEndDate] [datetime] NULL,
• D[ProductCategory] [nvarchar] (100) NOT NULL,
• E[OriginalProductCategory] [nvarchar] (100) NOT NULL,

• A
  14% (9)
• B
  76% (50)
• C
  8% (5)
• D
  3% (2)

Explanation

A Type 3 SCD supports storing two versions of a dimension member as separate columns. The table includes a column for the current value of a member plus either the original or previous value of the member. So Type 3 uses additional columns to track one key instance of history, rather than storing additional rows to track each change like in a Type 2 SCD. This type of tracking may be used for one or two columns in a dimension table. It is not common to use it for many members of the same table. It is often used in combination with Type 1 or Type https://k21academy.com/microsoft-azure/azure-data-engineer-dp203-q-a-day-2-live-session-

No community discussion yet for this question.