New Updated Microsoft MCP 70-467 Real Exam Questions and Answers Download 91-100

Ensurepass

QUESTION 91

DRAG DROP

You are designing a SQL Server Analysis Services (SSAS) data model on a very large

data warehouse.

 

The fact tables in the data warehouse contain terabytes of data in tens of billions of rows.

 

You must support the following features:

 

clip_image002Complex attribute/column relationships

clip_image002[1]Advanced calculations in the data model definition

clip_image002[2]Advanced calculations using logic deployed in a custom assembly

 

You need to choose the correct SSAS design strategy.

 

What should you do?

 

To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

 

clip_image004

 

Correct Answer:

clip_image006

 

 

QUESTION 92

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube. For Product A, Projected Revenue is defined as 150 percent of the Total Sales of the product. For all other products, Projected Revenue is defined as 110 percent of the Total Sales of the product. You need to calculate the Projected Revenue as efficiently as possible. Which calculation should you use? (More than one answer choice may achieve the goal.

Select the BEST answer.)

 

clip_image008

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: C

 

 

QUESTION 93

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.

 

clip_image009

 

You have the following requirements:

 

clip_image002[3]Ensure that queries of the data model correctly display average student age by class.

clip_image002[4]Ensure that the solution supports role-based security and partitions.

clip_image002[5]Minimize development effort.

 

You need to design the data model.

 

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

 

A.

Create a multidimensional project and define measures and a many-to-many dimensional relationship. Create partitions in SQL Server Management Studio (SSMS).

B.

Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).

C.

Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).

D.

Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).

 

Correct Answer: A

 

 

 

 

 

 

 

 

 

 

 

 

QUESTION 94

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube. The cube includes a Customer dimension that contains a Geography hierarchy and a Gender attribute hierarchy. You need to return only the female customers in the Geography hierarchy. Which set should you use? (More than one an
swer choice may achieve the goal. Select the BEST answer.)

 

clip_image011

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: A

 

 

QUESTION 95

HOTSPOT

You are designing a SQL Server Integration Services (SSIS) package configuration strategy.

 

The package configuration must meet the following requirements:

 

clip_image002[6]Include multiple properties in a configuration.

clip_image002[7]Force packages to load all settings in the configuration.

clip_image002[8]Support Encrypting File System (EFS) formats.

 

You need to select the appropriate configuration. Which configuration type should you use?

 

To answer, select the appropriate option from the drop-down list in the dialog box.

 

clip_image012

 

Correct Answer:

clip_image013

 

 

 

 

 

 

 

 

 

 

QUESTION 96

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart.

 

You have the following requirements:

 

clip_image002[9]Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.

clip_image002[10]Ensure that users can generate the exception report in an XML format.

clip_image002[11]Use the minimum development effort.

 

You need to design the SSIS solution to meet the requirements.

 

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

 

A.

Use a Data Profiling task. Use a Data Flow task to extract the XML output of the Data Profiling task into a SQL Server table. Query the table to view the exceptions.

B.

Use Data Flow tasks to process the clean data.

C.

Use a Data Profiling task. Read the exceptions in Data Profile Viewer.

D.

Design a stored procedure that examines data for common dirty data patterns. Use an Execute SQL task.

 

Correct Answer: C

 

 

QUESTION 97

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.

 

You have the following requirements:

 

clip_image002[12]The deployment model must support changing the content of connection strings by using parameters at execution time.

clip_image002[13]The deployment model must automatically log events to the SSISOB database.

clip_image002[14]Maximize performance at execution time.

 

You need to design a solution that meets the requirements.

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

 

A.

Use a project deployment model. Modify connection manager properties to use project parameters.

B.

Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.

C.

Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.

D.

Use a project deployment model. Modify connection manager properties to use package parameters.

 

Correct Answer: A

 

 

QUESTION 98

HOTSPOT

You are setting role permissions for a SQL Server Analysis Service (SSAS) cube. You plan to grant Read access for specific attribute members only to specific Active Directory security groups. You need to enter a Multidimensional Expressions (MDX) expression to configure the attribute member access. On which tab should you enter the MDX expression? To answer, select the appropriate tab in the answer area.

 

clip_image014

 

Correct Answer:

 

 

QUESTION 99

You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured. You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

Migrate SSRS content to a separate instance of SSRS 2012 on the same server.

B.

Perform an in-place upgrade of the SSRS environment.

C.

Migrate SSRS content to new servers that run SSRS 2012.

D.

Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.

 

Correct Answer: C

 

 

QUESTION 100

You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.

 

A.

Use the Usage-Based Optimization Wizard to create aggregations for the current partitions.

B.

Use the Aggregation Design Wizard to create aggregations for the current partitions.

C.

Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations.

D.

Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations.

 

Correct Answer: C

 

 

Instant Access to Download Latest Complete Collection of Microsoft MCP 70-467 Real Exam

Try Microsoft MCP 70-467 Free Demo