You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?
A.
Use the SQL Server Data Tools Dimension Wizard and generate a time table on the
server.
B.
Create a CSV file with time data and use the DMX IMPORT statement to import data from
the CSV file.
C.
Create a time dimension by using the Define dimension intelligence option in the
Business Intelligence Wizard.
D.
Create a time dimension by using the Define time intelligence option in the Business
Intelligence Wizard.
https://msdn.microsoft.com/en-us/ms174832.aspx
A is correct
D would generate time dimension in the data source