This page was exported from Lead2pass New Updated Exam Questions [ https://www.getfreevce.com ] Export date:Sun Dec 22 16:25:35 2024 / +0000 GMT ___________________________________________________ Title: Easily Pass 70-458 Exam with the Help of Lead2pass New Microsoft 70-458 VCE and PDF Dumps (21-30) --------------------------------------------------- Lead2pass 70-458 study guides are patterned into Questions and Answers pdf format and test engine and it will sharpen your skills and expand your knowledge to obtain a definite success. Everything you need to prepare and quickly pass the 70-458 certification exams the first time ,can be found in Lead2pass study guides. QUESTION 21 Drag and Drop Question You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute SQL task named Set Batch Success to mark the batch as successful. You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or Load Products task fails. Which three steps 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: Explanation: http://msdn.microsoft.com/en-us/library/ms141003.aspx http://msdn.microsoft.com/en-us/library/ms141261.aspx http://msdn.microsoft.com/en-us/library/ms141722.aspx http://msdn.microsoft.com/en-us/library/ms139895.aspx QUESTION 22 Drag and Drop Question You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related data to a staging table named Order. Every night the staging data is truncated and then all the recent orders from the online store database are inserted into the staging table. Your package must meet the following requirements: - If the truncate operation fails, the package execution must stop and report an error. - If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be rolled back. - For auditing purposes, a log entry must be entered in a SQL log table after each execution of the Data Flow task. The TransactionOption property for the package is set to Required. You need to design the package to meet the requirements. How should you design the control flow for the package? (To answer, drag the appropriate setting from the list of settings to the correct location or locations in the answer area.) Answer: Explanation: http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms141144.aspx QUESTION 23 Drag and Drop Question You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model. The project contains many packages. It is deployed on a server named Development!. The project will be deployed to several servers that run SQL Server 2012. The project accepts one required parameter. The data type of the parameter is a string. A SQL Agent job is created that will call the master.dtsx package in the project. A job step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter. You need to configure SSIS on the Development1 server to pass the Environment Variable to the package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.) Answer: Explanation: http://msdn.microsoft.com/en-us/library/hh479588.aspx http://msdn.microsoft.com/en-us/library/hh213230.aspx http://msdn.microsoft.com/en-us/library/hh213214.aspx QUESTION 24 Drag and Drop Question You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The package uses a Lookup transformation to find matches between the source and destination. The data flow has the following requirements: - New rows must be inserted. - Lookup failures must be written to a flat file. In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows to no match output. You need to configure the package to direct data into the correct destinations. How should you design the data flow outputs? (To answer, drag the appropriate transformation from the list of answer options to the correct location in the answer area.) Answer: Explanation: http://msdn.microsoft.com/en-us/library/ms141821.aspx http://msdn.microsoft.com/en-us/library/bb895366.aspx QUESTION 25 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. Answer: A Explanation: http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms141144.aspx QUESTION 26 Hotspot Question 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. Answer: Explanation: 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 QUESTION 27 You are designing a SQL Server Integration Services (SS1S) 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.    OnProgress B.    Onlnformation C.    OnPostExecute D.    OnComplete Answer: C Explanation: http://msdn.microsoft.com/en-us/library/ms140223.aspx QUESTION 28 You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each job passes a different folder path to the package. You need to configure the package to accept the folder path from each job. Which package configuration should you use? A.    .dtsConfig file B.    Registry Entry C.     Environment Variable D.    Parent Package Variable E.    XML Configuration File Answer: C QUESTION 29 Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been transferred. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. 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: A Explanation: http://msdn.microsoft.com/en-us/library/ms141212.aspx http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012- part-1-of-2/ http://www.mssqltips.com/sqlservertip/2450/ssis-package-deployment-model-in-sql-server-2012- part-2-of-2/ QUESTION 30 Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database, The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS catalog on the production server. 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: I Explanation: http://msdn.microsoft.com/en-us/library/hh231102.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx Lead2pass Microsoft 70-458 exam practice questions and answers are ideal for the aspiring candidates to grab exceptional grades in Microsoft exams. Lead2pass Microsoft 70-458 question answers are developed using the latest updated course content and all the answers are verified to ensure phenomenal preparation for the actual exam. Our 70-458 exam dumps will help you feel confident. http://www.lead2pass.com/70-458.html --------------------------------------------------- Images: http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps152E.tmp_thumb4_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps6E46.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wpsAD59.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wpsEC8B.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps1C53.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps59E0.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps7B27.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wpsB4CD.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wpsDFD4.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps2656.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps5B5B.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/ae36389c11f7_F354/wps8A48.tmp_thumb_thumb.png --------------------------------------------------- --------------------------------------------------- Post date: 2014-12-24 09:28:54 Post date GMT: 2014-12-24 09:28:54 Post modified date: 2014-12-24 09:28:54 Post modified date GMT: 2014-12-24 09:28:54 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com