Answer-first summary for fast verification
Answer: Populate the date dimension table by using a data flow., Populate the date dimension table by using a Stored procedure activity in a pipeline.
The technical requirements specify that the date dimension must contain dates from 2010 through the end of the current year and that there is no existing data source for this dimension. This means you will need a method to dynamically generate these dates. Option A (Populate the date dimension table by using a data flow) is a valid solution because data flows can be designed to generate a range of dates dynamically. Option D (Populate the date dimension table by using a Stored procedure activity in a pipeline) is also valid because a stored procedure can be written to generate and populate the date dimension table dynamically. Options B (Copy activity) and C (using T-SQL to populate a view) are not suitable because there is no existing source data to copy from, and a view cannot generate data it does not already have.
Author: LeetQuiz Editorial Team
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.
No comments yet.