Microsoft 070-466 valid exam dumps : Implementing Data Models and Reports with Microsoft SQL Server

You are creating a new report in SQL Server Report Builder. You add a Microsoft 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 Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries 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 are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level. It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A. 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.
• B. Add a measure that uses the Count aggregate function to an existing measure group.
• C. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• D. Use role playing dimensions.
• E. Use the Business Intelligence Wizard to define dimension intelligence.
• F. 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.
• G. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• H. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• I. 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.
• J. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• K. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• L. 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.
• M. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• N. 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.
• O. Create several dimensions. Add each dimension to the cube.

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)

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 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.
• B. Add a measure that uses the Count aggregate function to an existing measure group.
• C. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• D. Use role playing dimensions.
• E. Use the Business Intelligence Wizard to define dimension intelligence.
• F. 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.
• G. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• H. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• I. 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.
• J. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• K. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• L. 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.
• M. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• N. 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.
• O. Create several dimensions. Add each dimension to the cube.

HOTSPOT
You create a new SharePoint site to store reports for the manufacturing department.
You need to recommend a solution to meet the security requirements for the sales department users and the manufacturing department users.
What should you recommend? To answer, select the appropriate group for the sales department users and the manufacturing department users in the answer area.