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

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Country field on the rows and a grouping of the Year field on the columns.
You need to add the categories on the rows of the matrix.
Which Row Group option should you select when you add the group?

• A.Child Group
• B.Adjacent Below
• C.Adjacent Above
• D.Parent Group

You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.set the DefaultMember property to the Forecast member.
• B.Set the Usage property to Parent.
• C.Set the IsAggregatable property to False.
• D.Set the AttributeHierarchyVisible property to False.
• E.Set the AttributeHierarchyEnabled property to False.
• F.Set the RootMemberIf property to ParentIsMissing.

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)

• A.Option A
• B.Option B
• C.Option D
• D.Option C

HOTSPOT
A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option.
You have the following requirements to reduce the cube processing time:
Partition the measure group by month.
Create a staging table that contains only data which is more recent than the last
time the cube was processed.
Do not include data updates or deletions in the staging table.
Insert records from the staging table into the appropriate partition.
You need to change the process option to meet the requirements.
Which process option should you choose?
-- --
To answer, select the appropriate option from the drop-down list in the dialog box.

正解：

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?

• A.Set the SortExpression property to =Fields!Price. Name for the Price text box.
• B.Add a group for the Price field.
• C.In the Expression dialog box for the Price text box. enter the =SortByFieldslPrice, Value expression.
• D.Set the SortExpression property to =Fields!Price. Value for the Price text box.