Ensurepass.com : Ensure you pass the IT Exams
2018 May Microsoft Official New Released 70-466
100% Free Download! 100% Pass Guaranteed!

Implementing Data Models and Reports with Microsoft SQL Server 2014

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

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

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

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

3. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter.

4. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter.

Answer: C

#### Question No: 93 – (Topic 4)

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day.

You define a connection.

You need to ensure that the connection minimizes the attack surface area of the server.

How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)

1. Use your domain credentials. Grant least privilege to your account in the source database.

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

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

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

Answer:

Explanation:

Process Add

#### Question No: 95 – (Topic 4)

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).

The report contains tables, images, charts, page breaks, gauges, and indicators.

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

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

2. After development, test the report in a web browser.

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

4. 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?

1. Adjacent Below

2. Child Group

3. Parent Group

4. 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?

1. RSWindowsKerberos

2. RSWindowsNegotiate

3. RSWindowsNTLM

4. RSWindowsBasic

Answer: D Explanation:

Ref: http://msdn.microsoft.com/en-us/library/ms157273.aspx

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

1. Manage models

2. Manage reports

3. View reports

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

1. Analysis Services Deployment Wizard

2. Analysis Management Objects (AMO) automation

3. Backup and Restore

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

Ref: http://technet.microsoft.com/en-us/library/ms174928(v=sql.110).aspx

#### Question No: 100 – (Topic 4)

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache.

You need to configure the appropriate query mode. Which query mode should you select?

1. DirectQuery with In-Memory

2. In-Memory with DirectQuery

3. In-Memory

4. DirectQuery

Answer: C

#### 100% Ensurepass Free Download!–Download Free Demo:70-466 Demo PDF100% Ensurepass Free Guaranteed!–70-466 Dumps 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 table.table1{font-family: "Trebuchet MS", sans-serif;font-size: 16px;font-weight: bold;line-height: 1.4em;font-style: normal;border-collapse:Aprarate;} .table1 thead th{text-align:center;padding:8px;color:#fff;text-shadow:1px 1px 1px #568F23;border:1px solid #FFF;border-bottom:3px solid #9ED929;background-color:#9DD929;background:-webkit-gradient(linear,left bottom,left top,color-stop(0.02, rgb(123,192,67)),color-stop(0.51, rgb(139,198,66)),color-stop(0.87, rgb(158,217,41)));background: -moz-linear-gradient(center bottom,rgb(123,192,67) 2%,rgb(139,198,66) 51%,rgb(158,217,41) 87%);-webkit-border-top-left-radius:5px;-webkit-border-top-right-radius:5px;-moz-border-radius:5px 5px 0px 0px;border-top-left-radius:5px;border-top-right-radius:5px;} .table1 thead th:empty{background:transparent;border:1px solid #FFF;} .table1 tbody th{text-align:center;color:#fff;text-shadow:1px 1px 1px #568F23;background-color:#9DD929;border:1px solid #FFF;border-right:3px solid #9ED929;padding:2px 10px;background:-webkit-gradient(linear,left bottom,right top,color-stop(0.02, rgb(158,217,41)),color-stop(0.51, rgb(139,198,66)),color-stop(0.87, rgb(123,192,67)));background: -moz-linear-gradient(left bottom,rgb(158,217,41) 2%,rgb(139,198,66) 51%,rgb(123,192,67) 87%);-moz-border-radius:5px 0px 0px 5px;-webkit-border-top-left-radius:5px;-webkit-border-bottom-left-radius:5px;border-top-left-radius:5px;border-bottom-left-radius:5px;} .table1 tbody td{padding:5px 70px;text-align:center;background-color:#DEF3CA;border:1px solid #FFF;-moz-border-radius:2px;-webkit-border-radius:2px;border-radius:2px;color:#666;text-shadow:1px 1px 1px #fff;} .table1 tbody td.ep{text-align:center;background-color:#FFB5B5;border:1px solid #FFF;color:black;}

Comments are closed.