Free Microsoft 070-467 Exam Dumps Questions & Answers

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.

Correct Answer:

Explanation

You need to implement the date dimension in the Operations database.
What should you do?

• A.  Create one database dimension. Add three cube dimensions based on the database dimension. Set the Regular relationship type for each cube dimension.
• B.  Create three database dimensions. Add each database dimension as a cube dimension by setting the Referenced relationship type.
• C.  Create three database dimensions. Add each database dimension as a cube dimension by setting the Regular relationship type.
• D.  Create one database dimension. Add three cube dimensions based on the database dimension. Set the Referenced relationship type for each cube dimension.

You need to implement the aggregation designs for the cube.
What should you do?

• A.  Use the Usage-Based Optimization Wizard.
• B.  Use the Aggregation Design Wizard.
• C.  Create relational indexes on the source tables.
• D.  Use the CREATE CACHE statement.

• A.  M. every day.
• B.  Set the default schedule to refresh outside of business hours. Do not manually refresh the workbook.
• C.  Set the default schedule to refresh at 3:00 P.M. every day. Do not create individual source schedules.
• D.  Set the default schedule to refresh outside of business hours. Manually refresh the workbook at 9:00
• E.  Set the default schedule to refresh at 9:00 A.M. every day. Create a separate schedule for Source B's connection to refresh outside of business hours.
• F.  Set the default schedule to refresh at 9:00 A.M. every day. Do not create individual source schedules.

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.