This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Tue Apr 23 17:05:37 2024 / +0000 GMT ___________________________________________________ Title: PDF & VCE Format 70-458 Dumps With New Updated Exam Questions and Answers Free Downloa From Braindump2go (116-130) --------------------------------------------------- Braindump2go New Released Microsoft 70-458 Practice Tests Sample Questions Free Download! 100% Same Questions with Actual 70-458 Exam! Guaranteed 100% Pass! MicrosoftExam Code: 70-458Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Exam QUESTION 116You are a database administrator for a Microsoft SQL Server 2012 database named AdventureWorks2012.You create an Availability Group defined by the following schema. (Line numbers are included for reference only.) You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:- Production transactions should be minimally affected. - The secondary server should allow reporting queries to be performed. - If the primary server goes offline, the secondary server should not automatically take over.Which Transact-SQL statement should you insert at line 06? A.    Option AB.    Option BC.    Option CD.    Option DE.    Option E Answer: A QUESTION 117You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders.Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily fragmented.You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.Which Transact-SQL command should you use? A.    Option AB.    Option BC.    Option CD.    Option D Answer: C QUESTION 118You administer a Windows Azure SQL Database database named Orders.You need to create a copy of Orders named Orders_Reporting.Which Transact-SQL command should you use? A.    Option AB.    Option BC.    Option CD.    Option D Answer: A QUESTION 119Drag and Drop QuestionYou administer a Microsoft SQL Server database.You want to import data from a text file to the database.You need to ensure that the following requirements are met:- Data import is performed from a Windows batch file. - Data is loaded as a unit and is minimally logged.Which data import command and recovery model should you choose? (To answer, drag the appropriate data import command or recovery model to the appropriate location or locations in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.) Answer: QUESTION 120Drag and Drop QuestionYou are building a fact table In a data warehouse.The table must have a columnstore index. The table cannot be partitioned.You need to design the fact table and load it with data.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: QUESTION 121You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model. A package in the project extracts data from a Windows Azure SQL Database database. The package is deployed to SQL Server.The package is not producing the desired results.You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.What should you do? A.    Execute the catalog.create_execution_dump stored procedure with the package execution_id.B.    Run the DTEXEC utility with the /Reporting V option.C.    Run the DTEXEC utility with the /Logger option.D.    Execute the catalog.add_data_tap stored procedure with the package execution_id. Answer: A QUESTION 122A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store and is imported in parallel with the other files. The data flow tasks use OLE DB destinations in fast load data access mode.The number of daily transactions per store can be very large and is growing. The Transaction table does not have any indexes.You need to minimize the package execution time.What should you do? A.    Reduce the value of the Maximum Insert Commit Size property.B.    Partition the table by day and store.C.    Create a clustered index on the Transaction table.D.    Run the package in Performance mode. Answer: BExplanation:Partitioning the table would increase the large parallel imports. QUESTION 123Note: 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 deploying a new SQL Server Integration Services (SSIS) package to several servers.The package must meet the following requirements:- INET Common Language Runtime (CLR) integration in SQL Server must not be enabled.- The Connection Managers used in the package must be configurable without editing the package.- The deployment procedure must be automated as much as possible.You need to set up a deployment strategy that meets the requirements.What should you do? A.    Use the gacutil command.B.    use the dtutll /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: B QUESTION 124You 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.    Install ADOMD.NET.B.    Run the Configuration component in the Data Quality Client.C.    Run the DQSInstaller.exe command.D.    Make the data available for DQS operations. Answer: C QUESTION 125Hotspot QuestionYou are the data steward at your company.Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQSJ knowledge base and matching policy to identify these duplicate customers.)You need to identify the duplicate customers.Which option should you use? (To answer, select the appropriate option in the answer area.) Answer: QUESTION 126You are preparing to install SQL Server 2012 Master Data Services (MDS),You need to ensure that the database requirements are met.What should you install? A.    Microsoft SharePoint Server 2010 Enterprise Edition SP1B.    SQL Server 2012 Data Center (64-bit) x64 on the database serverC.    SQL Server 2012 Enterprise (64-bit) x64 on the database serverD.    SQL Server 2012 Standard (64-bit) x64 on the database server Answer: CExplanation:* Master Data Services is a new feature introduced in SQL Server 2008 R2 and further enhanced in SQL Server 2012.* SQL Server 2012 Enterprise features include Master Data Services: Note:* Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.Originally code-named Bulldog, Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features. Master Data Services first shipped with Microsoft SQL Server 2008 R2. QUESTION 127Hotspot QuestionYou are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to obtain the CDC data.The data source will be polled once per hour. The data is updated with multiple important status changes per minute.For each captured data change, the before and after values must be included.You need to configure the CDC Source component.Which CDC processing mode should you select? (To answer, configure the appropriate option in the dialog box in the answer area.) Answer: QUESTION 128A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database.To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP web service instead of from a weekly flat file.You need to implement the change to the existing package while minimizing the development effort.What should you use to call the web service to retrieve the daily exchange rates? A.    a Script componentB.    a Web Service sourceC.    a Web Service taskD.    a Script task Answer: C QUESTION 129You are developing a SQL Server Integration Services (SSIS) package.The package uses a data flow task to source data from a SQL Server database for loading into a dimension table in a data warehouse.You need to create a separate data flow path for data that has been modified since it was last processed.Which data flow components should you use to identify modified data? (Each correct answer presents a complete solution. Choose all that apply.) A.    Data ConversionB.    AggregateC.    LookupD.    MulticastE.    Slowly Changing Dimension Answer: CD QUESTION 130You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process,Which Transact-SQL batch should you use? A.    ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REORGANIZEB.    ALTER INDEX ALL ON AccountTransaction REBUILDC.    ALTER INDEX IDX_AccountTransaction_AccountCode ON AccountTransaction.AccountCode REBUILDD.    CREATE INDEX IDX AccountTransactionAccountCode ON AccountTransaction.AccountCode WITH DROP EXISTING Answer: B Braindump2go Offers PDF & VCE Dumps Download for New Released Microsoft 70-458 Exam! 100% Exam Success Guaranteed OR Full Money Back Instantly! http://www.braindump2go.com/70-458.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/110.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsC2F9.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsDB2B.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsF64B.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps17A1.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps3F7C.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps57BE.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps73C7.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps8861.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsAF72.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsC5A1.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsEA9F.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wpsBC7.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/wps1DA3.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/ff2388fc8c3d_C2DE/15.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-02-27 05:52:46 Post date GMT: 2015-02-27 05:52:46 Post modified date: 2015-02-27 05:52:46 Post modified date GMT: 2015-02-27 05:52:46 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com