Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Aug Microsoft Official New Released 70-470
100% Free Download! 100% Pass Guaranteed!

Recertification for MCSE: Business Intelligence

Question No: 171 – (Topic 9)

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.

Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.

  1. Partition the inventory fact table by month, and compress each partition.

  2. Partition the inventory fact table by day, and compress each partition.

  3. Partition the inventory fact table by year.

  4. Partition the inventory fact table by week.

Answer: B

Question No: 172 HOTSPOT – (Topic 9)

You administer a SQL Server Analysis Services (SSAS) cube.

You plan to optimize the cube partitions by using usage-based optimization. You need to configure the SSAS instance.

Which properties should you configure? To answer, select the appropriate properties in the dialog box in the answer area.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 173 DRAG DROP – (Topic 9)

Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.

The reports are running slowly. You plan to analyze report performance. You have the following requirements:

->Monitor query statistics on the production server with as little server overhead as possible.

->Gather, replay, and analyze statistics on the test server with as little administrative

effort as possible.

->Identify the longest-running queries on both servers.

->Document statistics on disk reads on both servers.

You need to gather statistics and meet the requirements.

Which features should you use?

To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 174 DRAG DROP – (Topic 9)

A company has a data warehouse that is rapidly increasing in size.

You plan to improve query performance by partitioning a very large fact table.

You need to identify the columns that are good partitioning candidates and the range that each partition should include.

Which component should you add to the package?

To answer, drag the appropriate component from the list of items to the answer area.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 175 – (Topic 9)

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:

->The deployment model must support changing the content of connection strings by using parameters at execution time.

->The deployment model must automatically log events to the SSISDB database.

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

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

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

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

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

Answer: A Explanation:

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

Question No: 176 – (Topic 9)

You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the prior day#39;s sales data.

The ETL process for the fact table must meet the following requirements:

->Load new data in the shortest possible time.

->Remove data that is more than 36 months old.

->Minimize record locking.

->Minimize impact on the transaction log.

You need to design an ETL process that meets the requirements.

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

  1. Partition the fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table.

  2. Partition the fact table by customer. Use partition switching both to remove old data and

    to load new data into each partition.

  3. Partition the fact table by date. Use partition switching and staging tables both to remove old data and to load new data.

  4. Partition the fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table.

Answer: C

Question No: 177 – (Topic 9)

You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.

The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B. Data from Source A is updated throughout the day.

Data from Source B is updated at 3:00 P.M.

You have the following requirements:

->Refresh the PowerPivot workbook with updated lookup data as soon as possible.

->Minimize load on the source systems and the SharePoint environment during business hours.

->Minimize user involvement in the data refresh process.

You enable automatic data refresh for the workbook.

You need to configure a data refresh schedule for the workbook that meets the requirements.

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

  1. Set the default schedule to refresh outside of business hours. Do not manually refresh the workbook.

  2. Set the default schedule to refresh outside of business hours. Manually refresh the workbook at 9:00 A.M. every day.

  3. Set the default schedule to refresh at 9:00 A.M. every day. Create a separate schedule for Source A#39;s connection to refresh outside of business hours.

  4. Set the default schedule to refresh at 3:00 P.M. every day. Do not create individual source schedules.

  5. Set the default schedule to refresh at 9:00 A.M. every day. Do not create individual

source schedules.

Answer: C

Question No: 178 – (Topic 9)

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

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

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

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

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

Answer: D

Question No: 179 – (Topic 9)

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.

The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.

You need to return only the blue products in the Category hierarchy.

Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Dumps4Cert 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: C

Question No: 180 DRAG DROP – (Topic 9)

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.

Dumps4Cert 2018 PDF and VCE

Answer:

Dumps4Cert 2018 PDF and VCE

100% Dumps4cert Free Download!
70-470 PDF
100% Dumps4cert Pass Guaranteed!
70-470 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

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