OFFER Free Microsoft 70-458 PDF and VCE Exam Dumps (11-20)

QUESTION 11
You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or inconsistent data. When the package finds invalid data, the row containing the invalid data must be omitted but it must also be written to a text file for further analysis. You need to establish the best technique to log these invalid rows while keeping the amount of development effort to a minimum. What should you do?

A.    Add an OnError event handler to the SSIS project.
B.    Use an msi file to deploy the package on the server.
C.    Open a command prompt and run the gacutil command.
D.    Open a command prompt and run the dtutil /copy command.
E.    Open a command prompt and run the dtexec /rep /conn command.
F.    Open a command prompt and run the dtexec /dumperror /conn command.
G.    Open a command prompt and execute the package by using the SQL Log provider and running
the dtexecui.exe utility.
H.    Create a reusable custom logging component and use it in the SSIS project.
I.    Configure the SSIS solution to use the Project Deployment Model.
J.    Configure the output of a component in the package data flow to use a data tap.
K.    Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in
SQL Server.

Answer: J
Explanation:
http://technet.microsoft.com/en-us/library/hh230989.aspx
http://www.rafael-salas.com/2012/01/ssis-2012-quick-peek-to-data-taps.html http://msdn.microsoft.com/en-us/library/ms162820.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx
http://technet.microsoft.com/en-us/library/ms140223.aspx
http://msdn.microsoft.com/en-us/library/jj655339.aspx

QUESTION 12
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements:
* Centralized logging in SQL Server
* Simple deployment
* Availability of log information through reports or T-SQL ?Automatic purge of older log entries
* Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

A.    Use the gacutil command.
B.    Use the dtutil /copy command.
C.    Use the Project Deployment Wizard.
D.    Create an OnError event handler.
E.    Create a reusable custom logging component.
F.    Run the package by using the dtexec /rep /conn command.
G.    Run the package by using the dtexec /dumperror /conn command.
H.    Run the package by using the dtexecui.exe utility and the SQL Log provider.
I.    Add a data tap on the output of a component in the package data flow.
J.    Deploy the package by using an msi file.
K.    Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to
store the configuration.

Answer: H
Explanation:
http://msdn.microsoft.com/en-us/library/ms140246.aspx
http://msdn.microsoft.com/en-us/library/hh231187.aspx

QUESTION 13
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors. Products for each distributor source must be combined for insertion into a single product table destination. You need to select the appropriate data flow transformation to meet this requirement. Which transformation types should you use? (Each correct answer presents a complete solution. Choose all that apply.)

A.    Multicast
B.    Merge Join
C.    Term Extraction
D.    union All
E.    Merge

Answer: DE
Explanation:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms141020.aspx
http://msdn.microsoft.com/en-us/library/ms141809.aspx http://msdn.microsoft.com/en-us/library/ms137701.aspx

QUESTION 14
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?

A.    Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
B.    Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
C.    Select the DropExistingMatchlndex option in the Fuzzy Lookup Transformation Editor.
D.    Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure
E.     Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.

Answer: A
Explanation:
http://msdn.microsoft.com/en-us/library/ms137786.aspx

QUESTION 15
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
Explanation:
http://msdn.microsoft.com/en-us/library/hh213137.aspx

QUESTION 16
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

Answer: D

QUESTION 17
You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?

A.    Run the Configuration component in the Data Quality Client.
B.    Install ADOMD.NET.
C.    Run the Data Quality Server Installer.
D.    Make the data available for DQS operations.

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/ff877917.aspx http://msdn.microsoft.com/en-us/library/gg492277.aspx

QUESTION 18
You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project. You need to produce the CSV file with the least amount of development effort. What should you do?

A.    Create an Integration Services package and use a Data Profiling transform.
B.    Create a custom .NET application based on the Knowledgebase class.
C.     Create a data quality project.
D.    Create a CLR stored procedure based on the Knowledgebase class.
E.    Create a Master Data Services (MDS) business rule.

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/hh213052.aspx
http://msdn.microsoft.com/en-us/library/ff877917.aspx
http://msdn.microsoft.com/en-us/library/microsoft.masterdataservices.services.datacontracts.knowledgebase.aspx http://msdn.microsoft.com/en-us/library/bb895263.aspx

QUESTION 19
You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven columns:
[ID]
[QuoteDate]
[Open]
[Close]
[High]
[Low]
[Volume]
Each of the following queries must be able to use a columnstore index:
SELECT AVG ([Close]) AS [AverageClose] FROM Quotes WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
SELECT AVG([High] – [Low]) AS [AverageRange] FROM Quotes WHERE [QuoteDate] BETWEEN ‘20100101’ AND
‘20101231’.
SELECT SUM([Volume]) AS [SumVolume] FROM Quotes WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
You need to ensure that the indexing strategy meets the requirements. The strategy must also minimize the number and size of the indexes. What should you do?

A.    Create one columnstore index that contains [ID], [Close], [High], [Low], [Volume], and [QuoteDate].
B.    Create three coiumnstore indexes:
One containing [QuoteDate] and [Close]
One containing [QuoteDate], [High], and [Low]
One containing [QuoteDate] and [Volume]
C.    Create one columnstore index that contains [QuoteDate], [Close], [High], [Low], and [Volume].
D.    Create two columnstore indexes:
One containing [ID], [QuoteDate], [Volume], and [Close] One containing [ID], [QuoteDate], [High], and [Low]

Answer: C
Explanation:
http://msdn.microsoft.com/en-us/library/gg492088.aspx
http://msdn.microsoft.com/en-us/library/gg492153.aspx

QUESTION 20
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: C
Explanation:
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/

If you want to pass Microsoft 70-458 successfully, donot missing to read latest lead2pass Microsoft 70-458 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

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

         

Why Choose Lead2pass?

If you want to pass the exam successfully in first attempt you have to choose the best IT study material provider, in my opinion, Lead2pass is one of the best way to prepare for the exam.

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back