Cause all that matters here is passing the Microsoft 70 463 exam exam. Cause all that you need is a high score of 70 463 exam Implementing a Data Warehouse with Microsoft SQL Server 2012 exam. The only one thing you need to do is downloading Examcollection 70 463 pdf exam study guides now. We will not let you down with our money-back guarantee.

Q9. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. 

The destination data load has the following requirements: . The identity values from the source table must be used. . Default constraints on the destination table must be ignored. . Batch size must be 100,000 rows. 

You need to add a destination and configure it to meet the requirements. 

Which destination should you use? 

A. OLE DB Destination with Fast Load 

B. SQL Server Destination 

C. ADO NET Destination without Bulk Insert 

D. ADO NET Destination with Bulk Insert 

E. OLE DB Destination without Fast Load 

Answer: A 

Reference: http://msdn.microsoft.com/en-us/library/ms141237.aspx 

Reference: http://msdn.microsoft.com/en-us/library/ms139821.aspx 

Reference: http://msdn.microsoft.com/en-us/library/ms141095.aspx 


Q10. A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in parallel with the other files. The data flow tasks use OLE DB destinations in fast load data access mode. 

The number of daily transactions per store can be very large and is growing- The Transaction table does not have any indexes. 

You need to minimize the package execution time. 

What should you do? 

A. Partition the table by day and store. 

B. Create a clustered index on the Transaction table. 

C. Run the package in Performance mode. 

D. Increase the value of the Row per Batch property. 

Answer: D 

Explanation: * Data Access Mode – This setting provides the 'fast load' option which internally uses a BULK INSERT statement for uploading data into the destination table instead of a simple INSERT statement (for each single row) as in the case for other options. 

* BULK INSERT parameters include: ROWS_PER_BATCH =rows_per_batch Indicates the approximate number of rows of data in the data file. By default, all the data in the data file is sent to the server as a single transaction, and the number of rows in the batch is unknown to the query optimizer. If you specify ROWS_PER_BATCH (with a value > 0) the server uses this value to optimize the bulk-import operation. The value specified for ROWS_PER_BATCH should approximately the same as the actual number of rows. 


Q11. To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. 

The following requirements must be met: 

. All the user information for a given Active Directory group must be downloaded to a SQL Server table. . The download process must traverse the Active Directory hierarchy recursively. 

You need to configure the package to meet the requirements by using the least development effort. 

Which item should you use? 

A. Script task 

B. Script component configured as a transformation 

C. Script component configured as a source 

D. Script component configured as a destination 

Answer: C 


Q12. You are designing a SQL Server Integration Services (SSIS) package configuration strategy. 

The package configuration must meet the following requirements: Include multiple properties in a configuration. Force packages to load all settings in the configuration. Support Encrypting File System (EFS) formats. You need to select the appropriate configuration. 

Which configuration type should you use? 

To answer, select the appropriate option from the drop-down list in the dialog box. 

Answer: 


Q13. You are completing the installation of the Data Quality Server component of SQL Server 

Data Quality Services (DQS). You need to complete the post-installation configuration. 

What should you do? 

A. Install the Analysis Services OLE DB Provider. 

B. Run the DQSInstaller.exe command. 

C. Run the Configuration component in the Data Quality Client. 

D. Make the data available for DQS operations. 

Answer: B 


Q14. You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day. 

The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. 

You need to reduce the report processing time and minimize the growth of the database. 

What should you do? 

A. Create an indexed view over the fact table to sum orderTotal by month. 

B. Create a view over the fact table to sum orderTotal by month. 

C. Change the granularity of the fact table to month. 

D. Partition the fact table by productKey. 

Answer: B 


Q15. You are building a fact table in a data warehouse. 

The table must have a columnstore index. The table cannot be partitioned. 

You need to design the fact table and load it with data. 

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

Answer: 


Q16. You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. 

The project will contain 10 packages. All the packages must connect to the same data source and destination. 

You need to define and reuse the connection managers in all the packages by using the least development effort. 

What should you do? 

A. Implement parent package variables. 

B. Copy and paste connection managers from one package to the others. 

C. Implement project connection managers. 

D. Implement package connection managers. 

Answer: C