Free Microsoft 070-467 Exam Dumps Questions & Answers

You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
* Members of the role must be able to update shared data sources.
* Members of the role must not be able to consume reports or manage subscriptions.
* The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.The Content Manager role
• B.The Browser role
• C.The Read and Process role
• D.The Publisher role

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

Correct Answer:

Explanation
Box 1:

Box 2:

You need to implement the product dimension.
What should you do?

• A.In the cube, create a named query that joins the Product and ProductColor tables in the financial database.
• B.In the data warehouse, create a product dimension from a view that joins the Product and ProductColor tables in the financial database and contains product name and product color attributes.
• C.In the data warehouse, create a product dimension table that contains product name and product color.
• D.In the data warehouse, create a dimension table that contains product name and a dimension table that contains product color.

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

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; Lookup, Aggregate, and Sort transformations; 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; a Script component; and a Flat File destination.