Question No: 91 DRAG DROP – (Topic 4)

You are developing a SQL Server PowerPivot model to monitor the rate of production of defective products.

The PowerPivot model contains many tables. The FactProduction table is configured as shown in the following diagram.

The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.

The KPI has the following requirements.

->If the rate of production of defective products equals or exceeds 5% then the KPI

must report a status of off target (red).

->If the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).

->If the rate of production of defective products less than 2% then the KPI must report a status of on target (green).

You need to develop the KPI to meet the requirements.

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.)

Answer:

Explanation: Box 1:

Box 2:

Box 3:

Note:

(Step 1, step 2): The model requires a key performance indicator (KPI) named Defective Units to measure the rate of production of defective units. The rate of production of defective units is calculated by dividing the sum of the Defects column by the sum of the Units column.

Step 3: The KPI has the following requirements.

鈥f the rate of production of defective products equals or exceeds 5% then the KPI must report a status of off target (red).

鈥f the rate of production of defective products is less than 5% and equals or exceeds 2% then the KPI must report a status of slightly off target (yellow).

鈥f the rate of production of defective products less than 2% then the KPI must report a status of on target (green).

Question No: 92 – (Topic 4)

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution.

You need to grant permission for salespersons to view only the data based on their sales territory.

What should you do?

Create a member and then create a Data Analysis Expressions (DAX) filter.

Create a member and then create a Multidimensional Expressions (MDX) filter.

Create and use a new Windows domain account. Grant least privilege to this account in the source database.

Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.

Use SQL Server authentication.

Answer: B

Question No: 94 HOTSPOT – (Topic 4)

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.

The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.

You need to ensure that all rows are available in the cube while minimizing the processing time.

Which processing option should you use? (To answer, select the appropriate option in the answer area.)

Question No: 95 – (Topic 4)

You need to ensure that the reports can be exported to Microsoft Excel and PDF formats and do not have any layout issues.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

During development, preview the report in the SSDT preview tab to validate its default HTML rendering.

After development, test the report in a web browser.

Increase the value of the Width property of the report body.

During development, preview the report in the SSDT preview tab and export it to the other rendering formats.

Answer: D

Question No: 96 – (Topic 4)

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.

You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows {the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.

You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.

You need to add the countries on the rows of the matrix.

Which Row Group option should you select when you add the group?

Adjacent Below

Child Group

Parent Group

Adjacent Above

Answer: A

Question No: 97 – (Topic 4)

You manage a SQL Server Reporting Services (SSRS) instance.

An application must pass credentials to the local security authority for Reporting Services.

You need to configure Reporting Services to issue a challenge/response when a connection is made without credentials.

Which authentication type should you configure in the RSReportServer.config file?

Question No: 98 – (Topic 4)

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.

The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders.

You need to modify the Folder Access Controller role so that the role members can view folders.

Which task should you add to the Folder Access Controller role?

Manage models

Manage reports

View reports

Manage folders

Answer: D

Question No: 99 – (Topic 4)

You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1.

You need to deploy DB1 from Server1 to four other servers. If the destination server already contains a copy of DB1, the database must be updated only. If the destination server does not contain a copy of DB1, the database must be copied to the destination server.

What is the best deployment option to use? More than one answer choice may achieve the goal. Select the BEST answer.

Analysis Services Deployment Wizard

Analysis Management Objects (AMO) automation

Backup and Restore

Synchronize Database Wizard

Answer: D

Explanation: In the Synchronize Database Wizard dialog box, type the name of the source server and source database in the appropriate fields.

Synchronization will occur for source and destination databases that have the same name. If the destination server already has a database that shares the same name as the source database, the destination database will be updated with the metadata and data of the source. If the database does not exist, it will be created on the destination server. Click Next.