[Free] 2017(Sep) EnsurePass Testking Microsoft 70-466 Dumps with VCE and PDF 21-30

EnsurePass
2017 Sep Microsoft Official New Released 70-466
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/70-466.html

Implementing Data Models and Reports with Microsoft SQL Server 2014

Question No: 21 – (Topic 2)

You need to configure SSRS to meet the maximum number of snapshots requirement. What should you do? (Each answer presents a complete solution. Choose all that apply.)

  1. In SharePoint Central Administration, set the System Snapshot Limit option to 5.

  2. In Reporting Services Configuration Manager, set the Limit number of snapshots option to 5.

  3. For each report, set the System Snapshot Limit option to 5.

  4. Use PowerShell to set the System Snapshot Limit option to 5.

Answer: A,C

Topic 3, Data Architect 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.)

Ensurepass 2017 PDF and VCE

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)

Additions and modifications to the data warehouse schema must adhere to star schema design principles to minimize maintenance and complexity

.

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 Standard Reports.

The cube design in the Standard Reports 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:

->A hierarchy must be created that consists of the SalesTerritoryCountry and SalesTerritoryRegion columns from the DimSalesTerritory table and the EmployeeName column from the DimEmployee table.

->A key performance indicator (KPI) must be created that compares the total 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.

Question No: 22 – (Topic 3)

You need to develop the multidimensional project to meet the requirements of the Excel users.

What should you do?

  1. Create a separate cube for the executive team so that it contains only the data they want to see.

  2. Create a perspective for the executive team.

  3. Create security roles to restrict access to the executive team.

  4. Create a view for the executive team.

Answer: B

Question No: 23 – (Topic 3)

You need to create the sales territory and product measures. Which aggregate function should you use for both measures?

  1. Count

  2. COUNT(DIST1NCT column_name)

  3. DistinctCount

  4. Distinct

Answer: C

Question No: 24 – (Topic 3)

You need to create a measure for DOD sales.

What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  1. Use the Data Analysis Expressions (DAX) PARALLELPERIOD ( ) function.

  2. Create a date dimension by using the Dimension wizard with a date template.

  3. Specify a date table by using a Mark the Date table.

  4. Use the Multidimensional Expressions (MDX) PARALLELPERIOD( ) function.

Answer: A,C

Question No: 25 – (Topic 3)

You need create the data source view for the StandardReports project. What should you do?

  1. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.

  2. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.

  3. Create a new data source view and then use the Import from Table wizard.

  4. Execute the Import from Table wizard and then use the Data Source View wizard.

Answer: A

Question No: 26 – (Topic 3)

You need to ascertain why Marc did not receive his reports. What should you do?

  1. Search the ReportServerService_lt;timestampgt;.log file for errors.

  2. Search the registry for errors.

  3. Use SQL Server Management Studio to search the SQL Server logs for errors.

  4. Use the Windows Event Viewer to search the Application log for errors.

Answer: A

Question No: 27 – (Topic 3)

You need to identify the reports that produce the errors that Marc is receiving. What should you do?

  1. Write a query by using the Subscriptions table in the report server database.

  2. Write a query by using the Execution Log 3 view in the report server database.

  3. Use the Windows Event Viewer to search the Application log for errors.

  4. Search the ReportServerService_lt;timestampgt;.log file for errors.

Answer: B

Question No: 28 – (Topic 3)

You need to create the KPI in the AdhocReports project in time for the next production release cycle.

What should you do?

  1. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.

  2. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.

  3. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.

  4. Create a measure by using the SUM((OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle.

Answer: D

Question No: 29 – (Topic 3)

You need to configure the SSRS data source. What should you do?

  1. Use Windows credentials.

  2. Prompt the user for credentials.

  3. In the data source configuration window, select the Credentials are not required option.

  4. Store the credentials.

Answer: A

Question No: 30 – (Topic 3)

You need to create the hierarchy in the AdhocReports project. What should you do?

  1. Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command.

  2. Use the RELATEDTABLE() function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command.

  3. Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command.

  4. Use the RELATED() function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command.

Answer: D

100% Free Download!
Download Free Demo:70-466 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass 70-466 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE

Leave a Reply