Pass with professional 70-460 actual quiz materials

Microsoft 70-460 Exam Overview:

Microsoft 70-460 Exam Syllabus Topics:

Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence Sample Questions:

1. You need to recommend a solution for the sales department that meets the security requirements.
What should you recommend?

A) Create one role for all of the sales department users. Configure the role to have read access to the sales transactions. Ensure that all of the reports that access the sales transaction data restrict read access to the data from the corresponding sales department region only.
B) Create one role for all of the sales department users. Add a DAX filter that reads the current user name and retrieves the user's region.
C) Create a table for each region. Create a role for each region. Grant each role read access to its corresponding table.
D) Create one role for each region. Configure each role to have read access to a specific region. Add the sales department users to their corresponding role.

2. You need to select the appropriate storage settings for the cube. Which settings should you choose?

A) hybrid OLAP (HOLAP) with proactive caching disabled
B) multidimensional OLAP (MOLAP) with proactive caching enabled and a rebuild interval of 24 hours
C) relational OLAP (ROLAP) with proactive caching enabled
D) hybrid OLAP (HOLAP) with proactive caching enabled

3. 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 nonadditive aggregation functions
B) Implement the cube as a local cube.
C) Ensure that the measure group measures only use semiadditive aggregation functions.
D) Implement the linked measure group as a local measure group.

4. 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 a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.
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 an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.

5. You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
- Members of the role must be able to update shared data sources.
- Members of the role must not be able to consume reports or manage
subscriptions.
- The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)

A) the Publisher role
B) the Read and Process role
C) the Content Manager role
D) the Browser role

Solutions: