Free Microsoft 070-470 Exam Dumps Questions & Answers

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server 2012 relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Use your domain credentials. Grant least privilege to your account in the source database.
• B.  Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.
• C.  Use SQL Server authentication.
• D.  Create and use a new Windows domain account. Grant least privilege to this account in the source database.

A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a state name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Build one report for each state and instruct users to execute reports as needed.
• B.  Use a report-specific data source that defines an expression-based connection string based on the state parameter.
• C.  Build a centralized data repository, schedule a regular Extract, Transform, and Load
  ---
  (ETL) process on all manufacturing data, and then use the repository to generate the report.
• D.  Use a shared data source that defines an expression-based connection string based on the state parameter.

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
- Report utility functions and business logic in code - Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
• B.  Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.
• C.  Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.
• D.  Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

• A.  Ensure that the measure group measures only use semiadditive aggregation functions.
• B.  Implement the cube as a local cube.
• C.  Implement the linked measure group as a local measure group.
• D.  Ensure that the measure group measures only use nonadditive aggregation functions

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?

• A.  Manage data sources
• B.  View models
• C.  View reports
• D.  Manage folders