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

---
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
A fact table is related to a dimension table named DimScenario by a column named ScenarioKey.
The dimension table contains three rows for the following scenarios:
Actual
Budget Q1
Budget Q3
You need to create a dimension to allow users to view and compare data by scenario.
What should you do?

• A.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• B.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• C.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• D.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• E.Use role playing dimensions.
• F.Use the Business Intelligence Wizard to define dimension intelligence.
• G.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• H.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• I.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• J.Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• K.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• L.Add a measure that uses the Count aggregate function to an existing measure group.
• M.Create several dimensions. Add each dimension to the cube.
• N.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• O.Create a dimension. Then add a cube dimension and link it several times to the measure group.

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) tabular project. The DirectQuery Mode property of the data model has been set to On. The current partition for the table is configured as the DirectQuery partition.
Data is loaded into a data mart throughout the day and must be available in the data model as soon as possible. The model must support querying by clients that issue both Data Analysis Expressions (DAX) queries and Multidimensional Expressions (MDX) queries. Clients issuing DAX queries must receive real-time query results.
You need to select the appropriate Query Mode property for deployment.
Which query mode should you select?
To answer, select the appropriate query mode from the drop-down list in the dialog box.

正解：

DRAG DROP
You are configuring an Excel Services service application in a Microsoft SharePoint farm.
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Use only terms that apply.)

正解：

You need to improve the performance of data warehouse queries.
What should you do?

• A.Create indexed views.
• B.Create bitmap indexes.
• C.Create columnstore indexes.
• D.Create clustered indexes.

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?

• A.Query Subcube
• B.Execute MDX Script Begin
• C.Query Begin
• D.Get Data From Aggregation
• E.Calculate Non Empty Begin
• F.Progress Report Begin