Latest MCSE 70-463 Real Exam Download 11-20

Ensurepass

 

QUESTION 11

You are designing an extract, transform, load (ETL) process with SQL Server Integration Services (SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package
B. Both packages must reference a file path corresponding to an input folder where files will be located for further processing. You need to design a solution so that the file path can be easily configured with the least administrative and development effort. Which four 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.)

 

Build List and Reorder:


 

Ensurepass 2017 PDF and VCE

 

Correct Answer:

clip_image002[4]

 

 

QUESTION 12

You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.

 

clip_image003[4]

 

clip_image005[14]You need to establish the correct order for loading each table to maximize parallel processing. Which order should you use?


A. 1. DimCurrency, DimScenario, DimAccount in parallel

2. DimOrganization

3. FactFinance

B. l. DimCurrency, DimOrganization in parallel

2. DimScenario, DimAccount in parallel

3. FactFinance

C. 1. DimCurrency, FactFinance in parallel

2. DimOrganization, DimScenario, DimAccount in parallel

D. 1. FactFinance

2. DimOrganization, DimScenario, DimAccount in parallel

3. DimCurrency

E. 1. DimCurrency

2. DimOrganization

3. DimScenario, DimAccount in parallel

4. FactFinance

 

Correct Answer: A

 

QUESTION 13

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

 

Correct Answer: A

 

QUESTION 14

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load. The package and all three Execute SQL product tasks have their TransactionOption property set to Supported. You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes. What should you do?

 

A. Change the TransactionOption property of the package to Required.

B. Change the TransactionOption property of all three Execute SQL product tasks to Required.
C. Move the three Execute SQL product tasks into a Foreach Loop container.

D. Move the three Execute SQL product tasks into a Sequence container.

 

Correct Answer: A

 

QUESTION 15

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 16

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


warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT

statement. The task has the following requirements:

clip_image005[15]clip_image005[16]The INSERT statement must use the value of a string package variable. The variable name is StringVar. The Execute SQL task must use an OLE DB Connection Manager.

 

In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter. You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?

 

A. INSERT INTO dbo.Table (variablevalue) VALUES ($Project::StringVar)

B. INSERT INTO dbo.Table (variablevalue) VALUES (@StringVar)

C. INSERT INTO dbo.Table (variablevalue) VALUES ($Package::StringVar)

D. INSERT INTO dbo.Table (variablevalue) VALUES (?)

 

Correct Answer: D

 

QUESTION 17

You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server

table on Server A. The package includes a data flow and is executed on ServerB. The destination table has its own identity column. The destination data load has the following requirements:

clip_image005[17]clip_image005[18]clip_image005[19]The identity values from the source table must be used. Default constraints on the destination table must be ignored. Batch size must be 100,000 rows.

 

You need to add a destination and configure it to meet the requirements. Which destination should you use?

 

A. ADO NET Destination with Bulk Insert

B. SQL Server Destination

C. OLE DB Destination with Fast Load

D. ADO NET Destination without Bulk Insert

E. OLE DB Destination without Fast Load

 

Correct Answer: C

 

QUESTION 18

You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored in a single table that contains the manager-to-subordinate relationships. You need to create a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?

 

A. Natural
B. Explicit
C. Parent

D. Recursive

 

Correct Answer: D

 

QUESTION 19

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 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. Change the similarity threshold to 0.55.


C. Change the similarity threshold to 0.40.

D. Increase the maximum number of matches per lookup.

 

Correct Answer: B

 

QUESTION 20

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

Download Latest 70-463 Real Free Tests , help you to pass exam 100%.

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.