Online Access Free 070-470 Exam Questions

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team does not need any information other than sales related resources in the tabular model. The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and administrative effort.
What should you do?

• A.Create a separate partition for each team.
• B.Create a separate data source for each team.
• C.Enable client side security to filter non-sales data.
• D.Create a perspective for the sales team.

---
A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.
A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RevenueData. Each RevenueData database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical. Reports must meet the following requirements:
A report parameter named ServerName must be defined in each report.
When running a report, users must be prompted to select a server instance.
The report data source must use the Microsoft SQL Server Analysis Services data
source type.
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of the data source?

• A.="Server=" & Parameters!ServerName.Value
• B.="Data Source=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"
• C.="Server=@ServerName;Initial Catalog=RevenueData"
• D.="Data Source=@ServerName;Initial Catalog=RevenueData"
• E.="Server=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:
- Implement drill-down browsing. - Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand. - Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural hierarchies.
• B.Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies.
• C.set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.
• D.Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.

DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.

The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that apply.)

• A.Use the current SSAS instance.
• B.Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
• C.Use the Database Synchronization Wizard to upgrade the database to tabular mode.
• D.Install a new instance of SSAS in tabular mode.
• E.Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.