29 02 2016

[2016 Feb-NEW][PDF&VCE]Braindump2go Latest 70-470 VCE Free Guarantee 100% Pass

itexams | 70-470 Dumps, 70-470 Exam Questions, 70-470 PDF, 70-470 VCE, Microsoft

2016 February NEW Updated 70-470 Exam Questions RELEASED Today!

2016 NEW 70-470 Exam Topics:

1.Build an analysis services multidimensional database
2.Manage, maintain, and troubleshoot a SQL Server Analysis Services (SSAS) database
3.Build a tabular data model
4.Build a report with SQL Server Reporting Services (SSRS)
5.Plan business intelligence (BI) infrastructure
6.Design BI infrastructure
7.Design a reporting solution
8.Design BI data models
9.Design an ETL solution

ATTENTION: 2016 NEW ADDED 70-470 Exam Questions are the most IMPORTANT!

QUESTION 271
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?

A.    Implement the cube as a local cube.
B.    Implement the linked measure group as a local measure group.
C.    Ensure that the measure group measures only use semiadditive aggregation functions.
D.    Ensure that the measure group measures only use nonadditive aggregation functions

Answer: B

QUESTION 272
Hotspot Question
You are designing a dimension named Employee for a SQL Server Analysis Services multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute in the answer area.

Answer:

QUESTION 273
Drag and Drop Question
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.

Answer:

QUESTION 274
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:
– Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.
– Sort rows in ProductID order.
– Aggregate product units sold.
– 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.

Answer: D

QUESTION 275
Hotspot Question
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.

Answer:

QUESTION 276
You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the solution.

A.    Back up the master database.
B.    Run sp.configure ‘clr enabled’, 0.
C.    Back up the master key of the SSISDB database.
D.    Back up the master key of the master database.
E.    Back up the SSISDB database.
F.    Run sp_configure ‘clr enabled’, 1.

Answer: CE

QUESTION 277
Hotspot Question
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:
– Users must be able to retrieve aggregate data from partition1 as quickly as possible.
– The processing time for partition1 and partition2 must be minimized.
– 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.

Answer:

QUESTION 278
Drag and Drop Question
You are designing a business intelligence (BI) solution for a hotel booking system. Each hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS) for the hotel booking system.
Which four 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:

QUESTION 279
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:
– An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
– 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.

Answer: D

QUESTION 280
You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning.
The cube consists of two measure groups named Sales and Planning.
Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group.
The Planning measure group consists of two measures:
– Forecast, which uses the Sum aggregate function
– Forecast Count, which uses the Count aggregate function
Users contribute planning values by using a legacy application.
An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse.
Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis.
You need to write-enable the Planning partition.
What should you do before write-enabling the partition?

A.    Set the ProcessingMode property of the Planning partition to LazyAggregations.
B.    Set the Type property of the Planning measure group to Budget.
C.    Remove the Forecast Count measure.
D.    Convert the Planning measure group to a linked measure group.
E.    Set the StorageMode property of the Planning partition to Rolap.
F.    Set the ProcessingMode property of the Planning measure group to LazyAggregations.

Answer: C
Explanation:
A cube can be write-enabled only if all its measures use the Sum aggregate function.

QUESTION 281
Drag and Drop Question
You have a cube named Cube1 that contains the sales data for your company.
You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments 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.

Answer:

QUESTION 282
A production SQL Server Analysis Services (SSAS) cube is processed daily.
The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension.
The table has the following structure.

The Product dimension has three attribute hierarchies:
Product
Subcategory
Category
The attributes have the following relationships defined: Product > Subcategory > Category.
Each attribute has a key and a name sourced from the related key and name columns in the DimProduct table.
During processing, you receive the following error message:
‘Errors in the OLAP storage engine:
A duplicate attribute key has been found when processing:
Table: ‘dbo_DimProduct’,
Column:
‘SubCategoryKey1, Value:
“23′. The attribute is Subcategory’.”
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

A.    Delete the Products hierarchy.
B.    Relate the Subcategory and Category attributes directly to the Product attribute.
C.    Remove the duplicate data from the DimProduct table.
D.    Remove the Subcategory attribute.

Answer: B

QUESTION 283
Hotspot Question
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for a running team.
The data warehouse used by the cube contains the time durations of taps run by each runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
– A measure named Measure1 that must contain the average time duration of the laps run by each runner.
– A measure named Measure2 that must contain the lap-time duration and the name of the runner who ran the fastest lap.
What should you do?
To answer, select the appropriate Aggregation Function property for each measure in the answer area.

Answer: