Microsoft Recertification for MCSE: Business Intelligence (070-470) Free Practice Test
Question 1
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
- The deployment model must support changing the content of connection strings by
using parameters at execution time.
- The deployment model must automatically log events to the SSISDB database.
- Maximize performance at execution time.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You have the following requirements:
- The deployment model must support changing the content of connection strings by
using parameters at execution time.
- The deployment model must automatically log events to the SSISDB database.
- Maximize performance at execution time.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 2
You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?
Which Multidimensional Expressions (MDX) function should you use?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 3
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?
Correct Answer: D
Question 4
DRAG DROP
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the
Default Account username used to provision shared services in the SharePoint farm. 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.)
You are planning the installation of PowerPivot for SharePoint.
You install SharePoint Server 2010 Enterprise Edition with Service Pack 1.
You need to install the PowerPivot for SharePoint instance. Then you need to configure the
Default Account username used to provision shared services in the SharePoint farm. 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:
Question 5
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the SalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?
Users of the cube report that the precision for the SalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?
Correct Answer: B
Question 6
A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Sales. Shared data sources exist in SSRS for the relational and SSAS databases. Each company department has its own report writers.
Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.
You have the following requirements:
- Ensure that only Marketing department report writers can access the custom
formula.
- Implement only one dataset.
- Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the Marketing department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.
You have the following requirements:
- Ensure that only Marketing department report writers can access the custom
formula.
- Implement only one dataset.
- Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the Marketing department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Correct Answer: C
Question 7
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: C,D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
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.)
- 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.)
Correct Answer: D
Question 9
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?
A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?
Correct Answer: C
Question 10
HOTSPOT
A school stores information about teachers, students, classes, and enrollments in a Windows Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report parameter displays the correct subjects for each teacher.
Which item should you configure? To answer, select the appropriate item in the answer area.
A school stores information about teachers, students, classes, and enrollments in a Windows Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.
Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.
You need to ensure that the report parameter displays the correct subjects for each teacher.
Which item should you configure? To answer, select the appropriate item in the answer area.
Correct Answer:
Question 11
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?
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?
Correct Answer: B