
Ultimate access to all questions.
As a Fabric Analytics Engineer at Litware, Inc., you need to create and implement a date dimension in the company's data store. The goal is to ensure that your dimensional model includes a comprehensive date dimension that will be used for various analytical purposes. Here are the specific requirements your solution must satisfy:
What are two ways to achieve this objective? Each correct answer will provide a complete solution.
NOTE: Each correct selection is worth one point.
A
Populate the date dimension table by using a data flow.
B
Populate the date dimension table by using a Copy activity in a pipeline.
C
Populate the date dimension view by using T-SQL.
D
Populate the date dimension table by using a Stored procedure activity in a pipeline.