2017 latest Microsoft 70-463 dumps pdf training materials and study guides update free try from lead4pass. High quality latest Microsoft 070-463 dumps pdf practice files and dumps vce youtube demo. https://www.leads4pass.com/70-463.html dumps exam training resources. The best Microsoft 70-463 dumps exam questions and answers download from lead4pass, pass Microsoft 70-463 exam test quickly and easily.
Latest Microsoft 70-463 dumps pdf training materials: https://drive.google.com/open?id=0B_7qiYkH83VRbWktYkNBcFJ1emM
Latest Microsoft 70-243 dumps pdf training materials: https://drive.google.com/open?id=0B_7qiYkH83VRS1BGaHdoc2dDLTg
Vendor: Microsoft
Certifications: MCSE
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012
Exam Code: 70-463
Total Questions: 230 Q&As
QUESTION 1
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 anddestination.
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.
Correct Answer: C
QUESTION 2
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job. 070-463 dumps
You make changes to the package that should improve performance.
You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.
What should you do?
A. Enable logging to an XML file in the package control flow for the Onlnformation event. After 10 executions, view the XML file.
B. After 10 executions, view the job history for the SQL Server Agent job.
C. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.
D. Enable logging to an XML file in the package control flow for the OnPostExecute event. After 10 executions, view the XML file.
Correct Answer: C
QUESTION 3
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.
Correct Answer: A
QUESTION 4
You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?
A. Microsoft SharePoint Server 2010 Standard Edition SP1
B. Microsoft SharePoint Server 2010 Enterprise Edition SP1
C. SQL Server 2012 Data Center (64-bit) x64 on the database server
D. SQL Server 2012 Enterprise (64-bit) x64 on the database server
Correct Answer: D
QUESTION 5
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 sales transaction data.
You create project parameters to store the username and password that are used to access the FTP site. 070-463 dumps
You need to ensure that the username and password values are encrypted when they are deployed.
What should you do?
A. Set the Sensitive property of the parameters to True.
B. Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.
C. Change the parameters to package parameters.
D. Change the project to the Legacy Deployment model.
Correct Answer: A
QUESTION 6
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. Create a time mapping table.
B. Change the level of granularity in both fact tables to be the same.
C. Merge the fact tables.
D. Create a view on the sales table.
Correct Answer: C
QUESTION 7
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. Depending on the value in a source column, the package redirects rows to one of five different data flow paths.
You need to add a data flow transformation to support the package redirection.
Which data flow transformation should you use?
A. Conditional Split
B. pjvot
C. Multicast
D. Lookup
Correct Answer: A
QUESTION 8
You are developing a SQL Server 1ntegration Services (SS1S) 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 sources should you use? Select Two
A. Raw File source
B. XML source
C. Custom source component
D. Flat File source
E. script component
Correct Answer: CE
QUESTION 9
You are designing an Extract, Transform and Load (ETL) solution that loads data into dimension tables.
The ETL process involves many transformation steps.
You need to ensure that the design can provide:
Auditing information for compliance and business user acceptance Tracking and unique identification of records for troubleshooting and error correction.
What should you do?
A. Develop a Master Data Services (MDS) solution.
B. Develop a Data Quality Services (DQS) solution.
C. Create a version control repository for the ETL solution.
D. Develop a custom data lineage solution.
Correct Answer: D
QUESTION 10
You have a secured database that contains all of the customer data for your company. You plan to use a project deployment model.
You need to create a SQL Server 1ntegration Services (SS1S) package that connects to the database by using a dedicated username and password. The solution must ensure that the password used for the connection string is encrypted. 070-463 dumps
Which two actions should you perform? (Select Two)
A. Select the Sensitive check box for the catalog environment.
B. Set the sensitive property of the package parameter to True.
C. Modify the set_execution parameter_value stored procedure.
D. Set the package protection level to EncrypSensitiveWithPassword.
Correct Answer: CD
Reference: https://www.leads4pass.com/70-463.html dumps pdf questions and answers free update.
Watch the video to learn more:
https://youtu.be/OMDqJxwOrBc