[Free] Get all latest Microsoft 70-467 Actual Tests 151-160

Ensurepass

QUESTION 151

You have a data warehouse named DW1. An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP storage mode. You create a SQL Server Integration Services (SSIS) package that updates DW1, and then processes Cube1. The package executes each day at 06:00. You need to configure the storage settings of Cube1. The solution must ensure that aggregation processing is reduced as much as possible during cube querying. What is the best storage setting you should you use for Cube1? More than one answer choice may achieve the goal. Select the BEST answer.

 

A.

Medium-latency MOLAP

B.

Scheduled MOLAP

C.

Low-latency MOLAP

D.

Automatic MOLAP

 

Correct Answer: D

 

 

QUESTION 152

HOTSPOT

You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and partition2.

 

You need to configure the storage mode for each cube partition.

 

The solution must meet the following requirements:

 

clip_image002Users must be able to retrieve aggregate data from partition1 as quickly as possible.

clip_image002[1]The processing time for partition1 and partition2 must be minimized.

clip_image002[2]The least possible amount of storage must be used for partition2.

 

What should you do? To answer, select the appropriate storage mode for each partition in the answer area.

 

clip_image003

 

Correct Answer:

clip_image004

 

 

QUESTION 153

DRAG DROP

You develop a SQL Server Integration Services (SSIS) project named Project1 by using SQL Server Data Tools (SSDT). Project1 contains a package named Package1.

 

You add a project parameter named EnvironmentText to Project1.

 

In SQL Server Management Studio (SSMS), you create the SSIS catalog.

 

You have the following requirements:

 

clip_image002[3]Configure Package1 so it can run within either a development environment or a test environment.

clip_image002[4]Pass the value of an SSIS environment variable to the EnvironmentText project parameter.

clip_image002[5]The value of the environment variable must be different for each SSIS environment.

 

You need to deploy the SSIS project and configure the SSIS environment.

 

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.

 

clip_image006

 

Correct Answer:

clip_image008

QUESTION 154

DRAG DROP

You install SQL Server Integration Services (SSIS) and develop an SSIS project to load a data warehouse. The project defines 10 parameters that have different values for the development, test and production environments. Some packages have additional parameters defined.

 

You plan to deploy the SSIS packages to one server. The server will also host the production data warehouse.

 

You need to deploy and configure the packages.

 

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.

 

clip_image010

 

Correct Answer:

clip_image012

QUESTION 155

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.

 

The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table.

 

You have the following requirements:

 

clip_image002[6]Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.

clip_image002[7]Sort rows in ProductID order.

clip_image002[8]Aggregate product units sold.

clip_image002[9]Minimize the time required to return the results.

 

You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.

 

You need to develop the Data Flow task.

 

What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

A.

A table-based OLE DB source; a Script component; and a Flat File destination.

B.

Only a SQL command-based OLE DB source and a Flat File destination.

C.

A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.

D.

A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.

 

Correct Answer: D

 

 

QUESTION 156

HOTSPOT

A company maintains separate environments for test, production, and quality assurance.

 

The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.

 

You create an SSIS project to perform a weekly refresh of the company’s data warehouse and cubes. The project has three packages.

 

You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.

 

Which program should you use?

 

To answer, select the appropriate program in the answer area.

 

clip_image013

 

Correct Answer:

clip_image014

 

 

 

 

 

 

 

 

 

 

QUESTION 157

DRAG DROP

You have a business intelligence (BI) infrastructure.

 

You create a SQL Server Integration Services (SSIS) project that contains the packages for the BI infrastructure.

 

You need to automate the deployment of the SSIS project. The solution must ensure that the deployment can occur as part of an unattended Transact-SQL script.

 

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.

 

clip_image016

 

Correct Answer:

clip_image018

 

 

QUESTION 158

You are creating a calculated measure in a sales cube by using a Multidimensional Expressions (MDX) calculation. The cube includes a date dimension. The date dimension has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes. The calculated measure must calculate the year-to-date sales for the current slicer. The MDX calculation must work for as many hierarchy levels as possible. You need to create a calculated measure for the cube that meets the requirements. Which expression should you use in the calculation designer? (More than one answer choice may achieve the goal. Select the BEST answer.)

 

clip_image019

 

A.

Option A

B.

Option B

C.

Option C

D.

Option D

 

Correct Answer: B

 

 

QUESTION 159

You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.

 

Customer dimension attributes will come from the following two sources:

 

clip_image002[10]An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.

clip_image002[11]A marketing database that contains thousands of rows of data representing customers’ geographic information. Attributes from this source will be updated monthly.

 

Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes.

 

You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.

 

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

 

A.

Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.

B.

Create one dimension table that combines data from both sources. Create a cube dimension for each source.

C.

Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.

D.

Create a dimension table for each source, and a cube dimension for each source.

 

Correct Answer: D

 

 

QUESTION 160

DRAG DROP

You have a business intelligence (BI) infrastructure that contains three servers. The servers are configured as shown in the following table.

 

clip_image020

 

You need to recommend a health monitoring solution for the BI infrastructure.

 

The solution must meet the following requirements:

 

clip_image002[12]Monitor the status of the Usage Data Collection feature.

clip_image002[13]Monitor the number of end-users accessing the solution.

clip_image002[14]Monitor the amount of cache used when the users query data.

 

Which health monitoring solution should you recommend using on each server? To answer, drag the appropriate monitoring solutions to the correct servers. Each monitoring solution may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

 

clip_image022

 

Correct Answer:

clip_image024

 

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

Instant Access to Try Microsoft 70-467 Free Demo

This entry was posted in 70-467 Actual Tests and tagged , , , , , . Bookmark the permalink.