Home » [Free] Get all latest Microsoft 70-467 Actual Tests 111-120

[Free] Get all latest Microsoft 70-467 Actual Tests 111-120

Ensurepass

QUESTION 111

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_image002

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: C

 

 

QUESTION 112

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_image003

 

You have the following requirements:

 

clip_image005Ensure that queries of the data model correctly display average student age by class.

clip_image005[1]Ensure that the solution supports role-based security and partitions.

clip_image005[2]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 113

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 answer choice may achieve the goal. Select the BEST answer.)

 

clip_image007

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: A

 

 

QUESTION 114

HOTSPOT

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

 

The package configuration must meet the following requirements:

 

clip_image005[3]Include multiple properties in a configuration.

clip_image005[4]Force packages to load all settings in the configuration.

clip_image005[5]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_image008

 

Correct Answer:

clip_image009

 

 

QUESTION 115

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_image005[6]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_image005[7]Ensure that users can generate the exception report in an XML format.

clip_image005[8]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

Explanation:

http://technet.microsoft.com/en-us/library/bb895263.aspx

 

 

 

 

 

QUESTION 116

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_image005[9]The deployment model must support changing the content of connection strings by using parameters at execution time.

clip_image005[10]The deployment model must automatically log events to the SSISDB database.

clip_image005[11]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

Explanation:

http://technet.microsoft.com/en-us/library/hh213290.aspx

 

 

QUESTION 117

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_image010

 

Correct Answer:

clip_image011

 

 

QUESTION 118

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 119

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. The FactSales5 partition contains the current year’s information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions. You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server. Several queries and reports are running very slowly. You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

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: A

 

 

QUESTION 120

HOTSPOT

A school stores information about teachers, students, classes, and enrollments in a Windows Azure SQL Database database. The database includes a table that maps the user IDs of teachers to the subjects they teach.

 

Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.

 

You are developing a report that displays a table of class enrollments for a specific subject. The report will prompt teachers to select from their mapped subjects. The table is based on a dataset named ClassData. To minimize report execution time, the ClassData dataset has been configured to cache all class enrollment data.

 

You need to ensure that the report parameter displays the correct subjects for each teacher.

 

Which item should you configure? To answer, select the appropriate item in the answer area.

 

clip_image013

 

Correct Answer:

clip_image015

 

Instant Access to Download Testing Software & PDF File for Microsoft 70-467 Real Exam

Instant Access to Try Microsoft 70-467 Free Demo

HOT EXAM!

Name of author

Name: admin