070-470 試験問題を無料オンラインアクセス

--- --
You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
Include a columnstore index.
Allow users to choose up to 10 dimension tables and up to five facts at one time.
Maximize performance of queries that aggregate measures by using any of the 10
dimensions.
Support billions of rows.
Use the most efficient design strategy.
You need to design the fact table to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns.
• B.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns.
• C.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns.
• D.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns.

You need to recommend a partitioning strategy that meets the performance requirements for CUBE1.
What should you include in the recommendation?

• A.Createa separate dimension for each distinct count attribute.
• B.Createone measure group for all distinct count measures.
• C.Createone dimension for all distinct count attributes.
• D.Create separate measure groups for each distinct count measure.

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk space and is doubling in size every month. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

• A.Tabular project that uses the DirectQuery query mode
• B.PowerPivot workbook deployed to SharePoint
• C.Multidimensional project
• D.Tabular project that uses the In-Memory query mode

The IT department is currently upgrading all SQL Server Integration Services (SSIS) packages to SSIS 2012.
The final version of a complex SSIS 2005 package has been overwritten. Four prior versions of the package exist. Each of the prior versions contains a different part of the final solution. You have backups of all associated project files.
You need to create an updated package as quickly and accurately as possible.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Upgrade the four package versions. Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields.
• B.Use the DataSet.Merge method to merge the compatible changes of the package versions by using the Lineage IDs. Upgrade the merged version.
• C.Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields. Upgrade the merged version.
• D.Upgrade the four package versions. Use SSIS Designer to visually compare the package versions, determine the compatible changes, and copy the compatible tasks into a single package.

DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer than usual.
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.)

正解：