Free Microsoft 70-470 Exam Dumps Questions & Answers

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.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

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

You need to design a cube partitioning strategy to be implemented as the cube size increases.
What should you do?

• A.Use relational OLAP (ROLAP) on all local partitions.
• B.Implement monthly local partitions.
• C.Implement monthly remote partitions.
• D.Use multidimensional OLAP (MOLAP) on all local partitions.

DRAG DROP
You need to complete the design of the data warehouse.
Which design should you use? (To answer, drag the appropriate tables and relationships to the correct location in the answer area. Use only the tables and relationships that apply.)

Correct 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?

• A.Use the Windows Event Viewer to search the Application log for errors.
• B.Write a query by using the Subscriptions table in the report server database.
• C.Write a query by using the ExecutionLog3 view in the report server database.
• D.Search the ReportServerService_<timestamp>.log file for errors.

You need to configure package execution logging to meet the requirements. What should you do?

• A.Configure logging in each ETL package to log the OnError, OnPreExecute, and OnPostExecute events.
• B.Set the SSIS catalog's Server-wide Default Logging Level property to Basic.
• C.Configure logging in each ETL package to log the OnError, OnInformation, and Diagnostic events.
• D.Set the SSIS catalog's Server-wide Default Logging Level property to Performance.
• E.Set the SSIS catalog's Server-wide Default Logging Level property to Verbose.