Microsoft 70-458 Practice Tests From People Who Created Microsoft 70-458 Exam (131-145)

2015 New Updated 70-458 Exam Dumps Questions and Answers are all from Microsoft Official Exam Center! Some new questions added into this new released 70-458 Dumps! Download 70-458 Exam Dumps Full Version Now and Pass one time!

Microsoft
Exam Code: 70-458
Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Exam

110

QUESTION 131
Drag and Drop Question
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide complete details for each record.
The data retrieved from each data source is sorted in ascending order by the ProductID column.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of transformations to the correct location in the answer area.)

wps1970.tmp_thumb

Answer:

wps2BB9.tmp_thumb

QUESTION 132
Hotspot Question
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.)

wps465C.tmp_thumb

Answer:

wps5AB7.tmp_thumb

QUESTION 133
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.    Merge Join
B.    DQS Cleansing
C.    Pivot
D.    CDC Splitter

Answer: C

QUESTION 134
Hotspot Question
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy.
The package reads rows from a source system and compares them to rows in a destination system.
New rows will be inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation.
The Lookup transformation joins the source and destination table on the business key, and includes all columns from the destination table in the data flow output.
The Conditional Split transformation inspects the destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)

wps7614.tmp_thumb

Answer:

wpsA6B6.tmp_thumb

QUESTION 135
Hotspot Question
You are developing a SQL Server Integration Services (SSIS) package.
The package contains a user-defined variable named @Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the @Queue variable equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)

wpsBEAA.tmp_thumb

Answer:

wpsD595.tmp_thumb

QUESTION 136
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model.
The project is deployed to a single SSIS catalog, and transfers data to and from multiple databases hosted on SQL Server.
The project must be configured to be able to export data to and from five different production servers that run SQL Server 2012.
Each target server requires different values for connection strings and parameters in the SSIS project.
You need to meet the requirements by using the least amount of administrative effort.
What should you do?

A.    For each target server, create separate Environments in the SSIS catalog of the host
SQL Server SSIS instance. Select the appropriate Environment at package execution time.
B.    Create one registry configuration. Add a connection string for each target server.
Choose the appropriate server in the package at build time.
C.    Create one XML configuration file. Add a connection string for each target server.
Choose the appropriate server in the package at build time.
D.    For each target server, create a separate package and include each package in the
SSIS catalog. Run the appropriate server at package execution time.

Answer: C

QUESTION 137
Drag and Drop Question
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.)

wpsF288.tmp_thumb

Answer:

wps9C1.tmp_thumb

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

Answer: BDF

QUESTION 139
Drag and Drop Question
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ActiveX Data Objects (ADO) source variable that holds a result set that was returned by a stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object source variable.
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.)

wps2434.tmp_thumb

Answer:

wps3593.tmp_thumb

QUESTION 140
You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts for all SQL Services.
You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber.
The distribution agent on ProdSrv2 regularly fails, displaying the following error message:
“Cannot access the file. Operating system error code 5 (Access is denied.).”
You need to configure the distribution agent by granting only the minimum required access to all accounts.
What should you do?

A.    Configure the SQL Server Agent service to run under the Local System account.
Configure the Subscriber to use the SQL Server Agent service account.
B.    Configure the SQL Server Agent service to run under a Windows domain account.
Configure the Subscriber to use the SQL Server Agent service account.
Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1.
C.    Configure the Subscriber to use the Local System account.
D.    Configure the Subscriber to use a Windows domain account.
Grant READ access for the domain account to the ReplData share on ProdSrv1.

Answer: D

QUESTION 141
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.    Matching Policy
D.    Matching

Answer: A

QUESTION 142
You are installing the Data Quality Server component of Data Quality Services.
You need to provision the hardware and install the software for the server that runs the Data Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met.
What should you do?

A.    Install Microsoft Internet Explorer 6.0 SP1 or later.
B.    Install SQL Server 2012 Database Engine.
C.    Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.
D.    Install the .NET Framework 4.0.

Answer: B

QUESTION 143
You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
– Every night, a very large amount of data is imported into the staging database.
– Package processing time must be minimized.
– The package must run on its own dedicated server when it is deployed to production.
– Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

A.    Raw File
B.    OLE DB
C.    ODBC
D.    Bulk Insert

Answer: B

QUESTION 144
Hotspot Question
You are developing a SQL Server Integration Service (SSIS) package.
The package loads a customer dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution.
You need to use the least amount of development effort to achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer area.)

wps654B.tmp_thumb[2]

Answer:

wps7AFE.tmp_thumb[3]

QUESTION 145
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database.
One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which Data Flow transformation should you use?

A.    Script Task
B.    Conditional Split
C.    Multicast
D.    Source Assistant

Answer: A
Explanation:
The Script component extends the data flow capabilities of Microsoft Integration Services packages with custom code written in Microsoft Visual Basic or Microsoft Visual C# that is compiled and executed at package run time. The Script component simplifies the development of a custom data flow source, transformation, or destination when the sources, transformations, and destinations included with Integration Services do not fully satisfy your requirements.


Guaranteed 100% Microsoft 70-458 Exam Pass OR Full Money Back! Braindump2go Provides you the latest 70-458 Dumps PDF & VCE for Instant Download!

15

http://www.braindump2go.com/70-458.html