[Apr 2016] sql server 2012 exam 70-463

Exact of 70-463 exam engine materials and braindumps for Microsoft certification for client, Real Success Guaranteed with Updated 70-463 pdf dumps vce Materials. 100% PASS Implementing a Data Warehouse with Microsoft SQL Server 2012 exam Today!

2016 Apr 70-463 Study Guide Questions:

Q1. A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog. 

To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed. 

You need to create these output files with the least amount of administrative and development effort. 

Which three stored procedures should you execute 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: 



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


Q3. You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model. 

The project contains many packages. It is deployed on a server named Development!. The project will be deployed to several servers that run SQL Server 2012. 

The project accepts one required parameter. The data type of the parameter is a string. 

A SQL Agent job is created that will call the master.dtsx package in the project. A job step is created for the SSIS package. 

The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. 

You need to configure SSIS on the Development1 server to pass the Environment Variable to the package. 

Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) 


Answer: 



Q4. A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors. 

You need to edit the package to log specific error messages. 

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: 



Q5. 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: 



70-463 dumps

Refresh microsoft learning 70-463:

Q6. You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. 

The SSIS package has the following requirements: 

Every night, a very large amount of data is imported into the staging database. 

Package processing time must be minimized. 

The package must run on its own dedicated server when it is deployed to 

production. 

Transaction log activity when data is imported must be minimized. 

You need to design the package to meet the requirements. 

Which destination component should you use? 

A. Raw File 

B. ODBC 

C. Bulk Insert 

D. OLE DB 

Answer: D 


Q7. You are developing a SQL Server Integration Services (SSIS) package. 

You use a Data Profiling task to examine the data from a source system. You need to establish: 

. The minimum and maximum dates for the datetime columns in the source data 

. The minimum, maximum, and average values for numeric columns in the source data 

You need to use the appropriate profile type in the Data Profiling task. 

Which profile type should you use? (To answer, select the appropriate profile type in the answer area.) 


Answer: 



Q8. You are developing a SQL Server Integration Services (SSIS) package. 

The package contains several tasks that must repeat until an expression evaluates to 

FALSE. 

You need to add and configure a container to enable this design. 

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: 



Q9. You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. 

The SQL Azure data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large. 

If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. 

The current setting for the Fuzzy Lookup similarity threshold is 0.50. 

Many values are incorrectly matched. 

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance. 

What should you do? 

A. Decrease the maximum number of matches per lookup. 

B. Change the similarity threshold to 0.55. 

C. Change the Exhaustive property to True. 

D. Increase the maximum number of matches per lookup. 

Answer: B 

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


Q10. You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. 

You are importing data from a relational table named Projects. The table has change data capture enabled on all columns. 

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package. 

Which query should you use as the data source? 


A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: D 

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

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

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


70-463 sample question

100% Guarantee 70-463 cbt nuggets free download:

Q11. You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure. 

The current dimension design does not allow the retention of historical changes to customer attributes such as Postcode. 

You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode. 

What should you do? 

A. Add StartDate and EndDate columns to the customer dimension. 

B. Add an IsCurrent column to the customer dimension. 

C. Enable Snapshot Isolation on the data warehouse. 

D. Add CurrentValue and PreviousValue columns to the customer dimension. 

Answer: A 


Q12. You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature. 

You have added a CDC Source component to the data flow to read changed data from the source system. 

You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations. 

Which data flow transformation should you use? 

A. DQS Cleansing 

B. Merge Join 

C. Pivot 

D. Conditional Split 

Answer: C 


Q13. You are developing a SQL Server Integration Services (SSIS) package. 

The package sources data from an HTML web page that lists product stock levels. 

You need to implement a data flow task that reads the product stock levels from the HTML web page. 

Which data flow source should you use? 

A. Use an msi file to deploy the package on the server. 

B. Open a command prompt and run the dtutil /copy command. 

C. Add an OnError event handler to the SSIS project. 

D. Open a command prompt and run the gacutil command. 

Answer: B 


Q14. You are developing a SQL Server Integration Services (SSIS) package. 

The package uses custom functionality that accesses a SQL Server database. The custom 

functionality must be implemented by using Language Integrated Query (LINQ). 

You need to ensure that the LINQ code can be debugged at design time. 

What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.) 


Answer: 



Q15. You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. 

The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. 

You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. 

What should you do? 

A. Add an OnError event handler to the SSIS project. 

B. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility. 

C. Use an msi file to deploy the package on the server. 

D. Open a command prompt and run the gacutil command. 

E. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server. 

F. Open a command prompt and run the dtutil /copy command. 

G. Create a reusable custom logging component and use it in the SSIS project. 

H. Configure the SSIS solution to use the Project Deployment Model. 

I. Configure the output of a component in the package data flow to use a data tap. 

J. Open a command prompt and run the dtexec /rep /conn command. 

K. Open a command prompt and run the dtexec /dumperror /conn command. 

Answer: I 

Explanation: 

References: http://technet.microsoft.com/en-us/library/hh230989.aspx 

http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/ms162820.aspx http://msdn.microsoft.com/en-us/library/hh231187.aspx http://technet.microsoft.com/en-us/library/ms140223.aspx http://msdn.microsoft.com/en-us/library/jj655339.aspx 


Q16. You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012. 

The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter. 

You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance. 

What should you do? 

A. Use an SSIS Script task that uses the custom assembly to parse the text data when inserting it. 

B. Use an SSIS Script transformation that uses the custom assembly to parse the text data when inserting it. 

C. Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data. 

D. Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to parse the text data, deploy it in the Windows Azure SQL Database database, and use it when inserting data. 

Answer: B 



see more http://www.2passeasy.com/exam/70-463/