Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-470
100% Free Download! 100% Pass Guaranteed!

Recertification for MCSE: Business Intelligence

Question No: 11 – (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 System Snapshot Limit option to 5.

  3. For each report, set the Limit number of snapshots option to 5.

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

Answer: A,C

Explanation: A: Reporting Services Service Applications are managed from SharePoint Central Administration. The Management and Properties pages allow you to update the configuration of the service application as well as common administration tasks.

Note:

  • From scenario: The system must support report snapshots. The default maximum number of retained snapshots must not exceed five.

  • System Snapshot Limit Default is -1, which is no limit.

Set a site-wide default value for the number of copies of report history to retain. The default value provides an initial setting that establishes the number of snapshots that can be stored for each report. You can specify different limits in property pages for specific reports.

Not B: Use the Reporting Services Configuration Manager to configure a Reporting Services Native Mode installation. If you installed a report server by using the files-only installation option, you must use this tool to configure the server before you can use it. If you installed a report server by using the default configuration installation option, you can use this tool to verify or modify the settings that were specified during setup.

Not D: SQL Server 2012 supports Windows PowerShell, which is a powerful scripting shell that lets administrators and developers automate server administration and application deployment.

Question No: 12 DRAG DROP – (Topic 2)

You need to optimize the Regions dimension.

How should you configure the attribute relationships? (To answer, drag the appropriate attribute from the list of attributes to the correct location in the hierarchy relationship. Use only attributes that apply.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Explanation:

Dumps4Cert 2018 PDF and VCE

C:\Users\Kamran\Desktop\02.png

Question No: 13 – (Topic 2)

You need to modify the Sales Regions hierarchy to meet the reporting requirements. Which S5A5 feature should you use?

  1. Calculation

  2. Translation

  3. Action

  4. Perspective

Answer: B

Question No: 14 – (Topic 2)

You need to configure per-user security authentication for reporting against the Sales cube.

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

  1. Create Service Principal Names (SPNs).

  2. Configure account delegation.

  3. Enable forms-based authentication.

  4. Enable mixed-mode authentication.

Answer: A,D

Explanation: * From scenario:

/ Administrative staff from around the world will produce sales reports with Microsoft Excel 2010 based on the Sales cube.

/ Security requirements

When possible, the system must use Windows authentication for all database connections. The system must prevent users from querying data from outside of their region.

The system must allow certain users to query data from multiple regions.

A: To use Kerberos authentication with SQL Server requires both the following conditions to be true:

The client and server computers must be part of the same Windows domain, or in trusted domains.

A Service Principal Name (SPN) must be registered with Active Directory, which assumes the role of the Key Distribution Center in a Windows domain. The SPN, after it is registered, maps to the Windows account that started the SQL Server instance service. If the SPN registration has not been performed or fails, the Windows security layer cannot determine the account associated with the SPN, and Kerberos authentication will not be used.

D: For windows authentication we need to enable mixed-mode authentication

Question No: 15 – (Topic 2)

You need to develop the executive reports.

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

  1. Remove default values from all parameters.

  2. Implement dataset query parameters to filter data.

  3. Set the data source to use Windows authentication.

  4. Set the data source to use stored Windows credentials.

  5. Provide default values for all parameters.

  6. Implement dataset filters to filter data.

Answer: B,D,E

Explanation: * From scenario:

Deliver executive reports that are parameterized and rendered from report snapshots

BD: The data source that the shared dataset is based on has Prompt or Windows Integrated credentials.

Question No: 16 – (Topic 2)

You need to configure the UserRegions role.

Which Multidimensional Expressions (MDX) function should you use?

  1. ANCESTOR ( )

  2. USERNAME ( )

  3. FIRSTSIBLING ( )

  4. LEAD ( )

  5. COUSIN ( )

Answer: B

Question No: 17 – (Topic 2)

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?

  1. DirectQuery

  2. In-Memory

  3. MOLAP

  4. Low-latency MOLAP

  5. Scheduled MOLAP

  6. High-latency MOLAP

Answer: D

Question No: 18 – (Topic 2)

You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

  1. Use the Windows Azure SQL Database data source type and then set Windows authentication for the credentials.

  2. Use the Windows Azure SQL Database data source type and then set a username and password for the credentials.

  3. Use the SQL Server data source type and then set a username and password for the credentials.

  4. Use the SQL Server data source type and then set Windows authentication for the credentials.

Answer: B

Question No: 19 – (Topic 2)

You need to modify the Sales cube to support the planning requirements. Which SSA5 feature should you use?

  1. At KPI

  2. A translation

  3. A writeback partition

  4. A perspective

Answer: C

Question No: 20 – (Topic 2)

You need to configure the partition storage settings to support the reporting requirements. Which partition storage setting should you use?

  1. Low-latency MOLAP

  2. In-Memory

  3. High-latency MOLAP

  4. Regular

  5. DirectQuery

  6. LazyAggregations

Answer: A

100% Dumps4cert Free Download!
70-470 PDF
100% Dumps4cert Pass Guaranteed!
70-470 Dumps

Dumps4cert 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.