New Updated Microsoft MCSE 70-466 Real Exam Questions and Answers Download 11-20

Ensurepass

QUESTION 11

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

  3. In-Memory

  4. In-Memory with DirectQuery

 

Correct Answer: C

 

 

QUESTION 12

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall over time. You need to use an appropriate project type. Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

 

  1. a tabular project that uses the DirectQuery query mode

  2. a tabular project that uses the In-Memory query mode

  3. a multidimensional project that uses the ROLAP storage mode and columnstore indexes

  4. a multidimensional project that uses the MOLAP storage mode and proactive cache

  5. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

 

Correct Answer: ABE

 

 

QUESTION 13

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates. You need to create a measure to report on year-over-year growth of profit. What should you do? (Each answer presents a complete solution. Choose all that apply.)

 

  1. Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.

  2. Define the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD(‘Date'[Date], 1, YEAR))

  3. Define the following calculation. Year Over Year Profit Growth:=[Profit] – CALCULATE([Profit], SAMEPERIODLASTYEAR(‘Date'[Date]))

  4. Define the following calculation. Year Over Year Profit Growth:=[Profit] – CALCULATE([Profit], PARALLELPERIOD(‘Date'[Date], -12, MONTH))

 

Correct Answer: CD

 

 

QUESTION 14

You are conducting a design review of a multidimensional project. In the geography dimension, all non-key attributes relate directly to the key attribute. The underlying data of the geography dimension supports relationships between attributes. You need to increase query and dimension processing performance. What should you do?

 

  1. For the dimension attributes of the geography dimension, define appropriate attribute relationships.

  2. For the geography dimension, set the ProcessingMode property to LazyAggregations.

  3. For the geography dimension, set the ProcessingPriority property to 1.

  4. For the dimension attributes of the geography dimension, set the GroupingBehavior property to EncourageGrouping.

 

Correct Answer: A

 

 

QUESTION 15

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions. You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis. What should you do before the partition can be write-enabled?

 

  1. Ensure that the measure group measures only use semiadditive aggregation functions.

  2. Implement the linked measure group as a local measure group.

  3. Implement the cube as a local cube.

  4. Ensure that the measure group measures only use nonadditive aggregation functions.

 

Correct Answer: B

 

 

QUESTION 16

You are developing a BI Semantic Model (BISM) that retrieves data from several sources including a SQL Azure database and an OData data feed. The model will be deployed to a server with significantly more memory than the total size of the source data. You have the data feed URL, which you will use when developing the model in SQL Server Data Tools (SSDT).

 

The model must meet the following requirements:

 

  • Maximize performance

  • Data latency of up to one month is acceptable

 

You need to choose a project type and a data access mode to meet the requirements. What should you do?

 

  1. Select the tabular project type and use the In-Memory query mode.

  2. Select the multidimensional project type and use the MOLAP storage mode.

  3. Select the multidimensional project type and use the ROLAP storage mode.

  4. Select the tabular project type and use the DirectQuery query mode.

 

Correct Answer: A

 

 

QUESTION 17

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 Multidimensional Expressions (MDX) filter.

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

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

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

 

Correct Answer: D

 

 

 

QUESTION 18

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Reports Writer is present on the server. The Reports Writer role cannot view and modify report caching parameters. You need to ensure that the Reports Writer role can view and modify report caching parameters. What should you do?

 

  1. Add the Manage individual subscriptions task to the Reports Writer role.

  2. Add the Manage all subscriptions task to the Reports Writer role.

  3. Add the View data sources task to the Reports Writer role.

  4. Add the Manage report history task to the Reports Writer role.

 

Correct Answer: D

 

 

QUESTION 19

You are developing a multidimensional project that includes
a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse.

 

The following diagram illustrates the table design.

 

70-466-demo-4

 

The Organization dimension includes a parent-child hierarchy named Organizations.

 

The dimension includes the following dimension attributes:

 

  • Organization, which is a key attribute

  • Organizations, which defines the parent-child hierarchy

  • Currency Code, which is a regular attribute

 

When users browse the dimension, three hierarchies are visible to them. You need to ensure that the Organization hierarchy is not visible to users. What should you do?

 

  1. Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.

  2. Set the AttributeHierarchyEnabled property to False for the Organization attribute.

  3. Delete the Organization attribute.

  4. Set the AttributeHierarchyVisible property to False for the Organization attribute.

Correct Answer: D

 

 

QUESTION 20

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting. A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RevenueData. Each RevenueData database stores data only for the continent in which it resides. All of the SSAS instances are configured identically.

 

The cube names and objects are identical. Reports must meet the following requirements:

 

  • A report parameter named ServerName must be defined in each report.

  • When running a report, users must be prompted to select a server instance.

  • The report data source must use the Microsoft SQL Server Analysis Services data source type.

 

You need to create a data source to meet the requirements. How should you define the expression that is assigned to the connection string property of the data source?

 

  1. =”Data Source=” & Parameters!ServerName.Value & “;Initial Catalog=RevenueData”

  2. =”Data Source=@ServerName;Initial Catalog=RevenueData”

  3. =”Server=@ServerName;Initial Catalog=RevenueData”

  4. =”Server=” & Parameters!ServerName.Value & “;Initial Catalog=RevenueData”

  5. =”Server=” & Parameters!ServerName.Value

 

Correct Answer: A

 

Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-466 Real Exam

Try Microsoft MCSE 70-466 Free Demo

Leave a Reply

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