2017 latest Microsoft MCSE 070-463 dumps exam questions and answers download free try from lead4pass. Prepare for Microsoft 070-463 exam test with best Microsoft MCSE 070-463 dumps pdf files and dumps vce youtube demo. https://www.leads4pass.com/70-463.html dumps exam training resources. High quality Microsoft MCSE 070-463 dumps pdf practice materials and study guides, pass Microsoft 070-463 exam test easily.
Latest Microsoft 70-463 dumps pdf questions and answers: https://drive.google.com/open?id=0B_7qiYkH83VRUTBGZlAtQTJWN2M
Latest Microsoft 70-461 dumps pdf questions and answers: https://drive.google.com/open?id=0B_7qiYkH83VRMDlXX3pPNWpnQWM
Vendor: Microsoft
Certifications: MCSE
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam Code: 070-463
Total Questions: 230 Q&As
QUESTION 1
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 closestmatching 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.
Correct Answer: B
QUESTION 2
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. 070-463 dumps
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 closestmatching 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 Exhaustive property to True.
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.
Correct Answer: B
QUESTION 3
You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?
A. Join the two fact tables.
B. Merge the fact tables.
C. Create a time dimension that can join to both fact tables at their respective granularity.
D. Create a surrogate key for the time dimension.
Correct Answer: C
QUESTION 4
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables.
You need to configure the SQL Server environment to support these packages.
What should you do?
A. Create SSIS configuration files for the packages.
B. Create an Integration Services catalog.
C. Install Data Quality Services.
D. Install Master Data services.
Correct Answer: B
QUESTION 5
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?
A. SQL Server Configuration Manager
B. SQL Server Agent
C. SSIS Upgrade Wizard in SQL Server Management Studio
D. SQL Server DTExecUI utility (dtexecui.exe)
Correct Answer: C
QUESTION 6
You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. 070-463 dumps
A package Connection Manager has been parameterized with project scope.
You need to display the parameters that have been generated for the Connection Manager.
What should you use? To answer, select the appropriate setting or settings in the answer area.
Correct Answer:
QUESTION 7
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.
Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.
You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all dimensional data from the three original solutions is represented.
What should you do?
A. Create a conformed dimension for the geography dimension.
B. Implement change tracking.
C. Create a degenerate dimension for the geography dimension.
D. Create a Type 2 slowly changing dimension for the geography dimension.
Correct Answer: A
QUESTION 8
You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.
The new capability is not available as an SSIS task. Each package must be extended with the same new capability.
You need to add the new capability to all the packages without copying the code between packages.
What should you do?
A. Use the Expression task.
B. Use the Script task.
C. Develop a custom task.
D. Use the Script component,
E. Develop a custom component.
Correct Answer: C
QUESTION 9
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors.
Products for each distributor source must be combined for insertion into a single product table destination.
You need to select the appropriate data flow transformation to meet this requirement.
Which transformation types should you use? (Each answer represents a complete solution. Choose all that apply.)
A. Slowly Changing Dimension
B. pivot
C. Lookup
D. Union All
E. Merge
Correct Answer: D,E
QUESTION 10
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?
A. Audit
B. Source Assistant
C. Script Task
D. Conditional Split
Correct Answer: D
QUESTION 11
A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the Project Deployment Model. 070-463 dumps
Sometimes the package is started as part of a multistep SQL job. At other times, the package is started manually by a database administrator by using the Object Explorer in SQL Server Management Studio.
You need to identify the authenticated user responsible for starting the package each time it executes.
How can you find this information?
A. In the SSISDB.[catalog], query the .[executions] view.
B. In the SSISDB.[catalog] , query the [event_messages] view.
C. In SQL Server Management Studio, view the SQL Agent Job History.
D. In SQL Server Management Studio, view the SQL Agent Error Log.
E. In SQL Server Management Studio, view the SQL Server Log.
Correct Answer: A
QUESTION 12
You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download data files.
You create project parameters to store the username and password that are used to access the FTP site.
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?
A. Convert the parameters to package parameters.
B. Set the Sensitive property of the parameters to True.
C. Set the ProtectionLevel property of the package to EncryptSensitiveWithPassword.
D. Convert the project to the Legacy Deployment model.
Correct Answer: B
Read more: https://www.leads4pass.com/70-463.html dumps exam questions and answers free update.
Watch the video to learn more: https://youtu.be/NO9vPSPhBJc
