Online Access Free 070-470 Exam Questions

You need to implement security in the cube to limit the sites visible to each user.
What should you do?

• A.Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
• B.Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
• C.Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
• D.Create an SSAS server role for each user and assign the sites each user can access to his or her server role.

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You create a degenerate dimension.
You need to define a relationship type for the dimension.
Which relationship type should you select? (To answer, configure the appropriate option or
options in the dialog box in the answer area.)

Correct Answer:

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 dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.
• B.For the Customer Geography dimension, set the ProcessingPriority property to 1.
• C.For the Customer Geography dimension, set the ProcessingMode property to LazyAggregations.
• D.For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.

DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer than usual.
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 are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

• A.Multidimensional project
• B.Tabular project that uses the In-Memory query mode
• C.Tabular project that uses the DirectQuery query mode
• D.PowerPivot workbook deployed to SharePoint