What are two ways to achieve the goal?

You need to implement the date dimension in the data store. The solution must meet the technical requirements.

What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . Populate the date dimension table by using a dataflow.
B . Populate the date dimension table by using a Stored procedure activity in a pipeline.
C . Populate the date dimension view by using T-SQL.
D . Populate the date dimension table by using a Copy activity in a pipeline.

View Answer

Answer: A, B

Explanation:

Both a dataflow (A) and a Stored procedure activity in a pipeline (B) are capable of creating and populating a date dimension table. A dataflow can perform the transformation needed to create the date dimension, and it aligns with the preference for using low-code tools for data ingestion when possible. A Stored procedure could be written to generate the necessary date dimension data and executed within a pipeline, which also adheres to the technical requirements for the PoC.