Try 2015 Latet Updated 70-463 Practice Exam Questions and Answers, Pass 70-463 Actual Test 100% in 2015 New Year! Braindump2go Latest released Free Sample 70-463 Exam Questions are shared for instant download! Braindump2go holds the confidence of 70-463 exam candiates with Microsoft Official Guaranteed 70-463 Exa Dumps Products! 238 New Updated Questions and Answers! 2015 Microsoft 70-463 100% Success!
Vendor: Microsoft
Exam Code: 70-463
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012 Exam
QUESTION 151
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model.
A package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?
A. Execute the catalog.add_data_tap stored procedure with the package execution_id.
B. Execute the catalog.create_execution_dump stored procedure with the package execution_id.
C. Run the DTEXEC utility with the /DumpOnError option.
D. Run the DTEXEC utility with the /Reporting V option.
Answer: C
QUESTION 152
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages.
All packages in the project must connect to the same database.
The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed.
You need to develop this project with the least amount of development effort.
What should you do? (Each answer presents a part of the solution. Choose all that apply.)
A. Create a package parameter named ConnectionName in each package.
B. Edit each package Connection Manager.
Set the ConnectionName property to @[$Project::ParamConnection].
C. Edit the project Connection Manager in Solution Explorer.
Set the ConnectionName property to @ [$Project::ParamConnection].
D. Set the Sensitive property of the parameter to True.
E. Create a project parameter named ConnectionName.
F. Set the Required property of the parameter to True.
Answer: CEF
Explanation:
C: From Question ” The server name for the database must be set by using a parameter named ParamConnection when any package in the project is executed.”
E: SSIS 2012 has introduced the concept of Project level connection managers. An SSIS project is generally more than one package. To simplify lives, the SSIS team now allows for the sharing of common resources across projects, connection managers being one of those resources.
F: When a parameter is marked as required, a server value or execution value must be specified for that parameter. Otherwise, the corresponding package does not execute. Although the parameter has a default value at design time, it will never be used once the project is deployed.
Note:
– Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level. Project parameters are used to supply any external input the project receives to one or more packages in the project. Package parameters allow you to modify package execution without having to edit and redeploy the package.
Reference: Integration Services (SSIS) Parameters
QUESTION 153
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. Raw File source
B. XML source
C. Custom source component
D. Flat File source
Answer: C
QUESTION 154
You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
– .NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.
– The Connection Managers used in the package must be configurable without editing and redeploying the package.
– The deployment procedure must be automated as much as possible.
– Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?
A. Add an OnError event handler to the SSIS project.
B. Use an msi file to deploy the package on the server.
C. Open a command prompt and run the gacutil command.
D. Open a command prompt and run the dtutil/copy command.
E. Open a command prompt and run the dtexec/rep/conn command.
F. Open a command prompt and run the dtexec/dumperror/conn command.
G. Open a command prompt and execute the package by using the SQL Log provider and
running the dtexecui.exe utility.
H. Create a reusable custom logging component and use it in the SSIS project.
I. Configure the SSIS solution to use the Project Deployment Model.
J. Configure the output of a component in the package data flow to use a data tap.
K. Run the dtutil command to deploy the package to the SSIS catalog and store the
configuration in SQL Server.
Answer: D
QUESTION 155
Drag and Drop Questions
You are maintaining a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that is implemented in Microsoft Visual C.
The implementation of the custom functionality changes overtime.
The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package.
You need to implement and deploy an update to the custom functionality without requiring package redeployment.
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:
QUESTION 156
Hotspot Questions
You are the data steward at your company.
Duplicate customers exist in a Microsoft Excel workbook.
You create a Data Quality Services (DQS) knowledge base and matching policy to identify these duplicate customers.
You need to identify the duplicate customers.
Which option should you use? (To answer, select the appropriate option in the answer area.)
Answer:
QUESTION 157
Hotspot Questions
You are developing a SQL Server Integration Services (SSIS) package.
The data source for the data flow task is a table that has been configured as a change data capture (CDC) table.
You are using a CDC Source component to obtain the CDC data.
The CDC Source component has the following requirements:
– The output must include metadata columns that indicate which source columns have changed.
– The output must return only one change row per source row that is modified in the current CDC processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Answer:
QUESTION 158
Hotspot Questions
You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)
![wpsFFE3.tmp_thumb[2]](http://www.itexamquiz.com/braindump2go/bdimages/adbd133c60fb_9D97/wpsFFE3.tmp_thumb2.png "wpsFFE3.tmp_thumb[2]")
Answer:
![wps1612.tmp_thumb[2]](http://www.itexamquiz.com/braindump2go/bdimages/adbd133c60fb_9D97/wps1612.tmp_thumb2.png "wps1612.tmp_thumb[2]")
QUESTION 159
Drag and Drop Questions
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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:
QUESTION 160
You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night.
The Windows Azure SQL Database 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. Change the similarity threshold to 0.40.
B. Decrease the maximum number of matches per lookup.
C. Change the similarity threshold to 0.85.
D. Increase the maximum number of matches per lookup.
Answer: C
Explanation:
– Similarity threshold
Set the similarity threshold at the component level by using the slider.
The closer the value is to 1, the closer the resemblance of the lookup value to the source value must be to qualify as a match. Increasing the threshold can improve the speed of matching since fewer candidate records need to be considered.
Incorrect:
– Maximum number of matches to output per lookup
Specify the maximum number of matches the transformation can return for each input row.
The default is 1.
Braindump2go Regular Updates of Microsoft 70-463 Preparation Materials Exam Dumps, with Accurate Answers, Keeps the Members One Step Ahead in the Real 70-463 Exam. Field Experts with more than 10 Years Experience in Certification Field work with us.
