What should you do?

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 in the data source.
B. Use the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.
C. Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
D. Create a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.