70-466 試験問題を無料オンラインアクセス

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.Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
• B.Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.
• C.Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
• D.Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to add a calculated member to the Customer dimension to evaluate the sum of values for France and Germany.
Which expression should you use? (To answer, drag the appropriate expression to the answer area.)

正解：

You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?

• A.For the Customer Geography dimension, set the ProcessingPriority property to 1.
• B.For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
• C.For the Customer Geography dimension, set the Processing Mode property to LazyAggregations.
• D.For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)

正解：

You need to create the KPI in the AdhocReports project.
What should you do?

• A.Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.
• B.Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• C.Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• D.Create a KPI based on the OrderQuantity column and then set the target value.