PrepAway - Latest Free Exam Questions & Answers

You need to implement a time dimension

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?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply