Pass with 070-460 Practice Materials 100% for sure

Microsoft 070-460 Exam Overview:

Microsoft 070-460 Exam Syllabus Topics:

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

Question 1

After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the
report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?

A. Modify the Rsmgrpolicy.config file.
B. From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
C. From Central Administration, modify the properties of the Reporting Service Application.
D. Modify the Rssrvrpolicy.config file.

Question 2

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report. You have an application that populates a table with user-specific subscription
schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.
B. Create a standard SSRS subscription for each subscription schedule.
C. Create a data-driven SSRS subscription for each record in the schedule table.
D. Create a standard SSRS subscription for each record in the table.

Question 3

HOTSPOT
A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.

Question 4

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

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

Question 5

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

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

Solutions: