Free Microsoft 70-467 Exam Dumps Questions & Answers

You need to implement a strategy for efficiently storing sales order data in the data warehouse.
What should you do?

• A.  Separate the factOrders table into multiple tables, one for each day that has orders, and use a local partitioned view.
• B.  Create monthly partitions in the factOrders table.
• C.  Separate the factOrders table into multiple tables, one for each month that has orders, and use a local partitioned view.
• D.  Create daily partitions in the factOrders table.

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 SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.
• B.  A table-based OLE DB source; a Script component; and a Flat File destination.
• C.  Only a SQL command-based OLE DB source and a Flat File destination.
• D.  A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.

You need to complete the following UPDATE statement to initialize the budget sales values for 2012.
Which MDX weight value expression should you use?
To answer, drag the appropriate weight value expression to the answer area.

Correct Answer:

Explanation

You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Customer is based on the DimCustomer table. A subset of the data source view is shown in the following graphic.

You need to relate the Customer dimension to the AccountBalance measure group.
Which relationship type should you choose? To answer, select the appropriate option from the drop-down list in the dialog box.

Correct Answer:

Explanation

A SQL Server Analysis Services (SSAS) cube named Sales includes a dimension named Date that defines a hierarchy named Calendar. The Calendar hierarchy consists of Year, Quarter, and Month levels. The Type properties of the Date dimension and its attributes are appropriately configured to mark the dimension as a time dimension.
You are creating a Multidimensional Expressions (MDX) query that will return sales for each month of 2011 and a three-month moving average of sales (labeled 3MMA), as shown in the following diagram.

You need to complete the MDX query.
Which set expression should you use? To answer, drag the appropriate expression to the answer area.

Correct Answer:

Explanation