This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Wed Apr 24 19:48:00 2024 / +0000 GMT ___________________________________________________ Title: Free New Updated 70-458 Practice Tests Dumps Questions and Answers from Microsoft Exam Center Braindump2go Guarantere You 100% 70-458 Pass (1-10) --------------------------------------------------- 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! Vendor: MicrosoftExam Code: 70-458Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 ExamQUESTION 1Hotspot QuestionYou administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition: You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard. You need to ensure that the following requirements are met:- The first row of the file contains the first row of data.- Each record is of the same length.- The date follows the U.S. date format.- The file supports international characters.What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.) Answer: QUESTION 2Drag and Drop QuestionYou administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the following definition: You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to include only rows that contain a value in the CarrierTrackingNumber column. Which four Transact- SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.) Answer: Explanation:http://msdn.microsoft.com/en-us/library/ms188783.aspx http://msdn.microsoft.com/en-us/library/ms189280.aspx QUESTION 3You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema. You need to ensure that the Sales role, including UserA, is disallowed to select from any of the tables in the Customers schema. Which Transact-SQL statement should you use? A.    REVOKE SELECT ON Schema::Customers FROM UserAB.    DENY SELECT ON Object::Regions FROM UserAC.    EXEC sp_addrolemember 'Sales', 'UserA'D.    DENY SELECT ON Object::Regions FROM SalesE.    REVOKE SELECT ON Object::Regions FROM UserAF.    DENY SELECT ON Schema::Customers FROM SalesG.    DENY SELECT ON Schema::Customers FROM UserAH.    EXEC sp_droproleraember 'Sales', 'UserA'I.    REVOKE SELECT ON Object::Regions FROM SalesJ.    REVOKE SELECT ON Schema::Customers FROM Sales Answer: FExplanation:http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx QUESTION 4You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema. You need to ensure that UserA is disallowed to select from the Regions table. Which Transact-SQL statement should you use? A.    DENY SELECT ON Object::Regions FROM SalesB.    DENY SELECT ON Schema::Customers FROM SalesC.    REVOKE SELECT ON Object::Regions FROM SalesD.    REVOKE SELECT ON Schema::Customers FROM SalesE.    DENY SELECT ON Object::Regions FROM UserAF.    DENY SELECT ON Schema::Customers FROM UserAG.    REVOKE SELECT ON Object::Regions FROM UserAH.    REVOKE SELECT ON Schema::Customers FROM UserAI.    EXEC sp_addrolemerr.ber 'Sales', 'DserA'J.    EXEC sp droprolemember 'Sales', 'UserA' Answer: EExplanation:http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx QUESTION 5You administer a SQL 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema. You need to remove the Select permission for UserA on the Regions table. You also need to ensure that UserA can still access all the tables in the Customers schema, including the Regions table, through the Sales role permissions. Which Transact-SQL statement should you use? A.    DENY SELECT ON Object::Regions FROM UserAB.    DENY SELECT ON Schema::Customers FROM UserAC.    EXEC sp_addrolemember 'Sales', 'UserA'D.    REVOKE SELECT ON Object:: Regions FROM UserAE.    REVOKE SELECT ON Object::Regions FROM SalesF.    EXEC sp_droproiemember 'Sales', 'DserA'G.    REVOKE SELECT ON Schema::Customers FROM UserAH.    DENY SELECT ON Object::Regions FROM SalesI.    DENY SELECT ON Schema:: Customers FROM SalesJ.    REVOKE SELECT ON Schema:: Customers FROM Sales Answer: DExplanation:http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx QUESTION 6You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema. You need to ensure that the following requirements are met:- The Sales role does not have the Select permission on the Customers schema. - UserA has the Select permission on the Regions table.Which Transact-SQL statement should you use? A.    DENY SELECT CN Object::Regions FROM SalesB.    DENY SELECT CN Schema::Customers FROM SalesC.    REVOKE SELECT ON Object::Regions FROM SalesD.    REVOKE SELECT ON Schema::Customers FROM SalesE.    DENY SELECT CN Object::Regions FRCM UserAF.    DENY SELECT CN Schema::Customers FRCM UserAG.    REVOKE SELECT ON Object::Regions FROM UserAH.    REVOKE SELECT ON Schema::Customers FOR UserAI.    EXEC sp addrolemember 'Sales', 'UserA'J.    EXEC sp droprolemember 'Sales'. 'UserA' Answer: DExplanation:http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx QUESTION 7You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:- A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is located on a dedicated LUN (drive E).- Drive D has 1 terabyte of free disk space.- Drive E has 5 GB of free disk space.The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You need to ensure that your backup will continue if any invalid checksum is encountered. Which backup option should you use? A.    STANDBYB.    DifferentialC.    FULLD.    CHECKSUME.    BULK_LOGGEDF.    CONTINUE_AFTER_ERRORG.    SIMPLEH.    DBO_ONLYI.    COPY_ONLYJ.    SKIPK.    RESTARTL.    Transaction logM.    NO_CHECKSUMN.    NORECOVERY Answer: F QUESTION 8You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:- A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is located on a dedicated LUN (drive E).- Drive D has 1 terabyte of free disk space.- Drive E has 5 GB of free disk space.The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version. You need to perform a full database backup that will be restored on the development server. Which backup option should you use? A.    NORECOVERYB.    FULLC.    NO_CHECKSUMD.    CHECKSUME.    DifferentialF.    BULK_LOGGEDG.    STANDBYH.    RESTARTI.    SKIPJ.    Transaction logK.    DBO ONLYL.    COPY_ONLYM.    SIMPLEN.    CONTINUE_AFTER_ERROR Answer: L QUESTION 9You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:- A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is located on a dedicated LUN (drive E).- Drive D has 1 terabyte of free disk space.- Drive E has 5 GB of free disk space.The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You implement log shipping of the financial database to another SQL Server 2012 instance. You decide to failover to this secondary database. You need to ensure that all transactions will be replicated to the secondary database. Which backup option should you use? A.    DifferentialB.    TransactionC.    FULLD.E.    SIMPLEBULK_LOGGEDF.    SKIPG.    RESTARTH.    STANDBYI.    CHECKSUMJ.    DBO_ONLYK.    COPY ONLYL.    NORECOVERYM.    NO_CHECKSUMN.    CONTINUE_AFTER_ERROR Answer: L QUESTION 10You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following characteristics:- A data file of 2 terabytes is located on a dedicated LUN (drive D). - A transaction log of 10 GB is located on a dedicated LUN (drive E).- Drive D has 1 terabyte of free disk space.- Drive E has 5 GB of free disk space.The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. These data load operations must occur in the minimum amount of time. A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. You need to ensure that the backup size is as small as possible. Which backup should you perform every two hours? A.    BULK_LOGGEDB.    NO_CHECKSUMC.    FULLD.    RESTARTE.    CHECKSUMF.    STANDBYG.    DBO.ONLYH.    NORECOVERYI.    SIMPLEJ.    SKIPK.    Transaction togL.    COPY_ONLYM.    DifferentialN.    CONTINUE_AFTER_ERROR Answer: K Guaranteed 100% Microsoft 70-458 Exam Pass OR Full Money Back! Braindump2go Provides you the latest 70-458 Dumps PDF & VCE for Instant Download! http://www.braindump2go.com/70-458.html --------------------------------------------------- Images: http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/110.png http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wpsF773.tmp_thumb2_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wps200A.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wps37AF.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wps54C2.tmp_thumb_thumb.png http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wps7859.tmp_thumb_thumb.jpg http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/wps9137.tmp_thumb_thumb.jpg http://www.itexamquiz.com/braindump2go/bdimages/df3369167ec0_A88A/15.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-02-26 03:59:58 Post date GMT: 2015-02-26 03:59:58 Post modified date: 2015-02-26 03:59:58 Post modified date GMT: 2015-02-26 03:59:58 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com