Home » Microsoft » 70-466 v.2 » 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 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.
Correct Answer: A
Explanation/Reference:
Explanation:
In Microsoft SQL Server Analysis Services, you can use the Dimension Wizard in SQL Server Data Tools (SSDT) to create a time dimension when no time table is available in the source database.
*Generate a time table on the server Select this option when you do not have permission to create objects in the underlying data source. The wizard will thengenerate and store a table on the server instead of in the data source. (The dimension created from a time table on the server is called a server time dimension.) The wizard then creates the server time dimension from this table.
*Generate a time table in the data source Select this option when you have permission to create objects in the underlying data source. The wizard will thengenerate a time table and store this table in the data source. The wizard then creates the time dimension from this time table.
References: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/create-a-time-dimension-by-generating-a-time-table