★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 70-463 Exam Dumps (PDF & VCE):
Available on: https://www.certleader.com/70-463-dumps.html


It is more faster and easier to pass the Microsoft 70-463 exam by using Approved Microsoft Implementing a Data Warehouse with Microsoft SQL Server 2012 questuins and answers. Immediate access to the Rebirth 70-463 Exam and find the same core area 70-463 questions with professionally verified answers, then PASS your exam with a high score now.

2021 Oct 70-463 vce download:

Q61. You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). 

You must develop an SSIS project and deploy it to the server by using the Project Deployment model. 

Operations Log records that are outside the configured retention period must be cleaned automatically. 

You need to create the SSIS catalog on the production server. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Enable XP Command Shell. 

B. Enable CLR Integration. 

C. Enable OLE Automation. 

D. Start the SQL Server Browser service. 

E. Enable Cross Database Ownership Chaining 

F. Start the SQL Server Agent service 

G. Enable Ad Hoc Remote Queries. 

Answer: B,F 


Q62. You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. 

A package in the project uses a custom task component. 

You need to ensure that the custom object is deployed on the test environment correctly. 

What should you do? 

A. Run the package by using the dtexec /rep /conn command. 

B. Create a reusable custom logging component. 

C. Create an OnError event handler. 

D. Use the gacutil command. 

E. Use the dtutil /copy command. 

F. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration. 

G. Run the package by using the dtexec /dumperror /conn command. 

H. Use the Project Deployment Wizard. 

I. Deploy the package by using an msi file. 

J. Add a data tap on the output of a component in the package data flow. 

K. Run the package by using the dtexecui.exe utility and the SQL Log provider. 

Answer:

Reference: 

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


Q63. 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. 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. (Click the Exhibit button.) 

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? (To answer, select the appropriate setting or settings in the answer area.) 

Select “IsolationLeve as Choas” References: 

http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms137749.aspx http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtscontainer.isolationlevel.aspx http://msdn.microsoft.com/en-us/library/ms173763.aspx 

Answer: 


Q64. You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package contains a data flow task that has 10 source-to-destination execution trees. 

Only five of the source-to-destination execution trees are running in parallel. 

You need to ensure that all the execution trees run in parallel. 

What should you do? 

A. Add OnError and OnWarning event handlers. 

B. Create a new project and add the package to the project. 

C. Query the ExecutionLog table. 

D. Add an Execute SQL task to the event handlers. 

Answer:


Q65. You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. 

You need to use DQS profiling to obtain the required statistics. 

Which DQS activity should you use? 

A. Cleansing 

B. Knowledge Discovery 

C. SQL Profiler 

D. Matching Rule Definition 

Answer:


Most recent vce 70-463:

Q66. You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table. 

You have the following requirements: 

. The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. . Before the sum is calculated, any records that have a price of zero must be discarded. 

You need to create the SSIS package in SQL Server Data Tools. 

In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.) 

Answer: 


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


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

Answer:

Explanation: References: 

http://msdn.microsoft.com/en-us/library/ms135965.aspx http://msdn.microsoft.com/en-us/library/ms345161.aspx 


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

Answer:

Explanation: References: http://msdn.microsoft.com/en-us/library/ms174537.aspx http://technet.microsoft.com/en-us/library/ms174832.aspx http://msdn.microsoft.com/en-us/library/ms174884.aspx http://decipherinfosys.wordpress.com/2007/02/01/surrogate-keys-vs-natural-keys-for-primary-key/ http://www.agiledata.org/essays/keys.html http://www.databasejournal.com/features/mssql/article.php/3922066/SQL-Server-Natural-Key-Verses-Surrogate-Key.htm http://www.jamesserra.com/archive/2012/01/surrogate-keys/ 


Q70. You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. 

The company's auditing policies have the following requirements: 

. An entry must be written to a dedicated SQL Server log table named OrderLog. . The entry must be written as soon as the file upload task completes. 

You need to meet the company's policy requirements. 

Which event handler should you use? 

A. OnPostExecute 

B. OnWarning 

C. OnExecStatusChanged 

D. OnVariableValueChanged 

Answer:

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