Prepare for Microsoft 70-463 exam test with best Microsoft MCSE 70-463 dumps exam questions and answers free download from lead4pass. Helpful newest Microsoft MCSE 70-463 dumps pdf files and vce youtube demo update free shared. “Implementing a Data Warehouse with Microsoft SQL Server 2012” is the name of Microsoft MCSE https://www.leads4pass.com/70-463.html exam dumps which covers all the knowledge points of the real Microsoft exam. Latest Microsoft MCSE 70-463 dumps exam training materials in PDF format update free try, pass Microsoft 70-463 exam test easily at first attempt.
Latest Microsoft 70-463 dumps pdf questions and answers: https://drive.google.com/open?id=0B_7qiYkH83VRbWktYkNBcFJ1emM
Latest Microsoft 70-486 dumps pdf questions and answers: https://drive.google.com/open?id=0B_7qiYkH83VRMDRTbjBZUUNoUmc
QUESTION 1
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.
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. After 10 executions, view the job history for the SQL Server Agent job.
B. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the project.
C. Enable logging to the Application Event Log in the package control flow for the Onlnformation event. After 10 executions, view the Application Event Log.
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: B
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.
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 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 4
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 5
You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. 70-463 dumps
In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to the DimProduct table take longer than expected.
You need to create a solution that uses a single command to perform an update and an insert.
How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area. You may need to drag the split bar between panes or scroll to view content.)
Select and Place:
Correct Answer:
QUESTION 6
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website instead of from a weekly flat file. The public website hosts a commaseparated values (CSV) file that contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?
A. a Script component
B. a Web Service task
C. a Web Service source
D. a Script task
Correct Answer: D
QUESTION 7
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.
Correct Answer: BEF
QUESTION 8
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 view on the sales table.
B. Partition the fact tables by day.
C. Create a surrogate key for the time dimension.
D. Change the level of granularity in both fact tables to be the same.
Correct Answer: D
QUESTION 9
You are designing a package control flow. The package moves sales order data from a SQL Azure transactional database to an on-premise reporting database. 70-463 dumps The package will run several times a day, while new sales orders are being added to the transactional database. The current design of the package control flow is shown in the answer area.
The Insert New Orders Data Flow task must meet the following requirements:
– Usage of the tempdb database should not be impacted.
– Concurrency should be maximized, while only reading committed transactions.
– If the task fails, only that task needs to be rolled back.
You need to configure the Insert New Orders Data Flow task to meet the requirements.
How should you configure the transaction properties?
Correct Answer: IsolationLevel = ReadCommited TransactionOption = Required
QUESTION 10
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 ServerParam 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 correct answer presents part of the solution. Choose all that apply.)
A. Set the Sensitive property of the parameter to True.
B. Edit each package Connection Manager. Set the ServerName property to @[$Project::ServerParam].
C. Edit the project Connection Manager in Solution Explorer. Set the ServerName property to @[$Project::ServerParam].
D. Create a project parameter named ServerName.
E. Create a package parameter named ServerName in each package.
F. Set the Required property of the parameter to True.
Correct Answer: BDF
QUESTION 11
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.
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
QUESTION 12
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 13
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. 70-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 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 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 14
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.
Correct Answer: C
QUESTION 15
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 trouble shooting 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
High quality Microsoft MCSE 70-463 dumps pdf practice materials and study guides free download from lead4pass. The best and most updated latest Microsoft MCSE https://www.leads4pass.com/70-463.html dumps pdf training resources which are the best for clearing 70-463 exam test, and to get certified by Microsoft MCSE, download one of the many PDF readers that are available for free.
Best Microsoft MCSE 70-463 dumps vce youtube: https://youtu.be/OMDqJxwOrBc