Pass with professional 070-460 actual quiz materials

You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that
apply.)

• A. Install a new instance of SSAS in tabular mode.
• B. Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
• C. Use the Database Synchronization Wizard to upgrade the database to tabular mode.
• D. Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.
• E. Use the current SSAS instance.

You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the solution.

• A. Run sp.configure 'clr enabled', 0.
• B. Back up the master key of the SSISDB database.
• C. Back up the SSISDB database.
• D. Back up the master database.
• E. Back up the master key of the master database.
• F. Run sp_configure 'clr enabled', 1.

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

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
- Report utility functions and business logic in code - Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
• B. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.
• C. Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.
• D. Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.

DRAG DROP
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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.)