★ 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


Exam Code: 70-463 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012
Certification Provider: Microsoft
Free Today! Guaranteed Training- Pass 70-463 Exam.

2021 Dec 70-463 exam download:

Q81. You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables. 

You have the following requirements: 

. Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. 

. Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database. 

. Maximize performance at execution time. 

. Minimize development effort. 

You need to design a solution that meets the requirements. 

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created. 

B. Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package. 

C. Use a package deployment model. Use a SQL Server package configuration with a common filter. Change the contents of the SSIS Configurations table at runtime. 

D. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments. 

Answer: A 


Q82. You are developing a SQL Server Integration Services (SSIS) package. 

You use a Data Profiling task to examine the data from a source system. You need to establish: 

. The minimum and maximum dates for the datetime columns in the source data 

. The minimum, maximum, and average values for numeric columns in the source data 

You need to use the appropriate profile type in the Data Profiling task. 

Which profile type should you use? (To answer, select the appropriate profile type in the answer area.) 

Answer: 


Q83. 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 that uses the SQL Server change data capture (CDC) feature. 

You have added a CDC Source component to the data flow to read changed data from the source system. 

You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations. 

Which data flow transformation should you use? 

A. Audit 

B. Merge Join 

C. Merge 

D. CDC Splitter 

Answer: C 

Explanation: MERGE with Incremental Loads The change data capture functionality that is new in SQL Server 2008 makes it easier to perform incremental loads reliably to a data warehouse. As an alternative to using parameterized OLE DB Command transformations to perform the inserts and the updates, you can use the MERGE statement to combine both operations. 


Q84. You manage a SQL Server Master Data Services (MDS) environment. 

A new application requires access to the product data that is available in the MDS repository. 

You need to design a solution that gives the application access to the product data with the least amount of development effort. 

What should you do? 

A. Create a Subscription View in MDS. 

B. Access the product entity tables in the MDS database directly. 

C. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging database. 

D. Use change data capture on the product entity tables. 

Answer: A 


Q85. You are installing the Data Quality Client on user desktops. 

You need to ensure that the prerequisite software components are installed. 

Which components must be present to meet this goal? (Each correct answer presents part of the solution. Choose all that apply.) 

A. SQL Server Management Studio 

B. Internet Explorer 6.0 SP1 or later 

C. Microsoft Silverlight 5 

D. .NET Framework 3.5 SP1 

E. .NET Framework 4.0 

F. Microsoft Silverlight 4 

G. SQL Server Data Tools 

Answer: B,E 

Explanation: Before installing DQS, make sure that your computer meets the minimum system requirements. 

Data Quality Client requirement: 

NET Framework 4.0 (installed during the Data Quality Client installation, if not already installed) 

Internet Explorer 6.0 SP1 or later 


Regenerate microsoft learning 70-463:

Q86. You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.) 

Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in the Employee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1? 

A. DateHired 

B. DepartmentID 

C. EmployeeID 

D. EmployeeNum 

E. FirstName 

F. JobTitle 

G. LastName 

H. MiddleName 

I. ReportsToID 

Answer: C 


Q87. You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL) statements on a SQL Azure database. The T-SQL statements may be executed in any order. The T-SQL statements have unpredictable execution times. 

You have the following requirements: 

. The package must maximize parallel processing of the T-SQL statements. 

. After all the T-SQL statements have completed, a Send Mail task must notify administrators. 

You need to design the SSIS package. 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: 


Q88. A SQL Server Integration Services (SSIS) package is designed to download data from a financial database hosted in SQL Azure. 

The connection string to the financial database is defined as a project parameter named FinConStr. The parameter value must be stored securely and must be set explicitly every time the package is executed. 

You need to configure the parameter to meet the requirements. 

What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.) 

Answer: 


Q89. You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. 

You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the ProjectDates table is the ProjectName column. 

The business user has given you the dimensional attribute behavior for each of the four columns in the ProjectDates table: 

ExpectedStartDate - New values should be tracked over time. 

ActualStartDate - New values should not be accepted. 

ExpectedEndDate - New values should replace existing values. 

ActualEndDate - New values should be tracked over time. 

You use the SSIS Slowly Changing Dimension Transformation. 

You must configure the Change Type value for each source column. 

Which Change Type values should you select? (To answer, drag the appropriate value from the list of values to the correct location or locations in the answer area.) 

Answer: 


Q90. You are developing a SQL Server Integration Services (SSIS) package. 

You need to design a package to change a variable value during package execution by using the least amount of development effort. 

What should you use? 

A. Expression task 

B. Script task 

C. Execute SQL task 

D. Execute Process task 

E. Term Extraction transformation 

Answer: A 

Reference: 

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