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.

2 Comments on “You need to implement a time dimension


Leave a Reply