Microsoft Recertification for MCSE: Business Intelligence - 070-470 Exam Practice Test
You need to configure package execution logging to meet the requirements. What should you do?
Correct Answer: E
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?
Correct Answer: E
Vote an answer
HOTSPOT
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.
Correct Answer:
You need to select an appropriate tool for creating the Regional Sales report.
Which tools or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Which tools or tools should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Correct Answer: B,D
Vote an answer
You need to recommend a cube architecture for CUBE1. The solution must meet the
performance requirements for CUBE1.
Which two partitions should you recommend creating? Each correct answer presents part of the solution.
performance requirements for CUBE1.
Which two partitions should you recommend creating? Each correct answer presents part of the solution.
Correct Answer: A,C
Vote an answer
DRAG DROP
You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.
You need to monitor the number of report data feed processing events during every automated execution.
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 administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.
You need to monitor the number of report data feed processing events during every automated execution.
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 need to implement security in the cube to limit the sites visible to each user.
What should you do?
What should you do?
Correct Answer: C
Vote an answer
Topic 1, Scenario 1
General Background
You are the data architect for a company that uses SQL Server 2012 Enterprise Edition. You design data modeling and reporting solutions that are based on a sales data warehouse.
Background
The solutions will be deployed on the following servers:
- ServerA runs SQL Server Database Engine. ServerA is the data warehouse server.
- ServerB runs SQL Server Database Engine, SQL Server Analysis Services (SSAS) in multidimensional mode, and SQL Server Integration Services (SSIS).
- ServerC runs SSAS in tabular mode, SQL Server Reporting Services (SSRS) running in SharePoint mode, and Microsoft SharePoint 2010 Enterprise Edition with SP1.
The data warehouse schema currently contains the tables shown in the exhibit. (Click the Exhibit button.)
Business Requirements
The reporting solution must address the requirements of the sales team, as follows: Team members must be able to view standard reports from SharePoint. Team members must be able to perform ad-hoc analysis by using Microsoft Power View and Excel. Team members can have standard reports delivered to them on a schedule of their choosing. The standard reports: Will use a sales territory hierarchy for organizing data by region. Will be accessible from SharePoint.
The Excel ad-hoc reports:
Will use the same data store as the standard reports.
Will provide direct access to the data store for the sales team and a simplified view
for the executive team.
Technical Requirements
The standard reports must be based on an SSAS cube. The schema of the data warehouse on ServerA must be able to support the ability to slice the fact data by the following dates:
- Order date (OrderDateKey) Due date DueDateKey Ship date (ShipDateKey) design principles to minimize maintenance and complexity. StandardReports.
A hierarchy must be created that consists of the SalesTerritoryCountry and A key performance indicator (KPI) must be created that compares the total
Additions and modifications to the data warehouse schema must adhere to star schema The multidimensional and tabular models will be based on the data warehouse. The tabular and multidimensional models will be created by using SQL Server Data Tools (SSDT). The tabular project is named AdhocReports and the multidimensional project is named The cube design in the StandardReports project must define two measures for the unique count of sales territories (SalesTerritoryKey) and products (ProductKey). A deployment script that can be executed from a command-line utility must be created to deploy the StandardReports project to ServerB. The tabular model in the AdhocReports project must meet the following requirements: - SalesTerritoryRegion columns from the DimSalesTerritory table and the EmployeeName column from the DimEmployee table.
- quantity sold (OrderQuantity) to a threshold value of 1,000.
- A measure must be created to calculate day-over-day (DOD) sales by region based on order date.
SSRS on ServerC must be configured to meet the following requirements:
- It must use a single data source for the standard reports.
- It must allow users to create their own standard report subscriptions.
- The sales team members must be limited to only viewing and subscribing to reports in the Sales Reports library.
A week after the reporting solution was deployed to production, Marc, a salesperson, indicated that he has never received reports for which he created an SSRS subscription.
In addition, Marc reports that he receives timeout errors when running some reports on demand.
A\Batch 1
============================================================================
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
General Background
You are the data architect for a company that uses SQL Server 2012 Enterprise Edition. You design data modeling and reporting solutions that are based on a sales data warehouse.
Background
The solutions will be deployed on the following servers:
- ServerA runs SQL Server Database Engine. ServerA is the data warehouse server.
- ServerB runs SQL Server Database Engine, SQL Server Analysis Services (SSAS) in multidimensional mode, and SQL Server Integration Services (SSIS).
- ServerC runs SSAS in tabular mode, SQL Server Reporting Services (SSRS) running in SharePoint mode, and Microsoft SharePoint 2010 Enterprise Edition with SP1.
The data warehouse schema currently contains the tables shown in the exhibit. (Click the Exhibit button.)
Business Requirements
The reporting solution must address the requirements of the sales team, as follows: Team members must be able to view standard reports from SharePoint. Team members must be able to perform ad-hoc analysis by using Microsoft Power View and Excel. Team members can have standard reports delivered to them on a schedule of their choosing. The standard reports: Will use a sales territory hierarchy for organizing data by region. Will be accessible from SharePoint.
The Excel ad-hoc reports:
Will use the same data store as the standard reports.
Will provide direct access to the data store for the sales team and a simplified view
for the executive team.
Technical Requirements
The standard reports must be based on an SSAS cube. The schema of the data warehouse on ServerA must be able to support the ability to slice the fact data by the following dates:
- Order date (OrderDateKey) Due date DueDateKey Ship date (ShipDateKey) design principles to minimize maintenance and complexity. StandardReports.
A hierarchy must be created that consists of the SalesTerritoryCountry and A key performance indicator (KPI) must be created that compares the total
Additions and modifications to the data warehouse schema must adhere to star schema The multidimensional and tabular models will be based on the data warehouse. The tabular and multidimensional models will be created by using SQL Server Data Tools (SSDT). The tabular project is named AdhocReports and the multidimensional project is named The cube design in the StandardReports project must define two measures for the unique count of sales territories (SalesTerritoryKey) and products (ProductKey). A deployment script that can be executed from a command-line utility must be created to deploy the StandardReports project to ServerB. The tabular model in the AdhocReports project must meet the following requirements: - SalesTerritoryRegion columns from the DimSalesTerritory table and the EmployeeName column from the DimEmployee table.
- quantity sold (OrderQuantity) to a threshold value of 1,000.
- A measure must be created to calculate day-over-day (DOD) sales by region based on order date.
SSRS on ServerC must be configured to meet the following requirements:
- It must use a single data source for the standard reports.
- It must allow users to create their own standard report subscriptions.
- The sales team members must be limited to only viewing and subscribing to reports in the Sales Reports library.
A week after the reporting solution was deployed to production, Marc, a salesperson, indicated that he has never received reports for which he created an SSRS subscription.
In addition, Marc reports that he receives timeout errors when running some reports on demand.
A\Batch 1
============================================================================
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
Correct Answer: C
Vote an answer
DRAG DROP
You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2012.
You need to import an existing PowerPivot workbook to create a tabular project.
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 have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2012.
You need to import an existing PowerPivot workbook to create a tabular project.
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:
