This page was exported from Lead2pass New Updated Exam Questions [ https://www.getfreevce.com ] Export date:Sun Dec 22 17:27:43 2024 / +0000 GMT ___________________________________________________ Title: Easily Pass 70-458 Exam with the Help of Lead2pass New Microsoft 70-458 VCE and PDF Dumps (61-70) --------------------------------------------------- Get yourself composed for Microsoft actual exam and upgrade your skills with Lead2pass Microsoft 70-458 practice test products. Once you have practiced through our assessment material, familiarity on Microsoft 70-458 exam domains get a significant boost. Lead2pass practice tests enable you to raise your performance level and assure the guaranteed success for Microsoft 70-458 exam . QUESTION 61 You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. You also need to maintain transactional consistency of the data across both servers. You need to achieve these goals without manual intervention. Which configuration should you use?A.    Two servers configured in a Windows Failover Cluster in the same data center SQL Server configured as a clustered instance B.    SQL Server that includes an application database configured to perform transactional replication C.    Two servers configured in the same data center A primary server configured to perform log-shipping every 10 minutes A backup server configured as a warm standby D.    Two servers configured in different data centers SQL Server Availability Group configured in Synchronous-Commit Availability Mode One server configured as an Active Secondary E.    Two servers configured in the same data center SQL Server Availability Group configured in Asynchronous-Commit Availability Mode One server configured as an Active Secondary F.    Two servers configured in different data centers SQL Server Availability Group configured in Asynchronous-Commit Availability Mode G.    SQL Server that includes an application database configured to perform snapshot replication H.    Two servers configured on the same subnet SQL Server Availability Group configured in Synchronous-Commit Availability Mode Answer: H Explanation: http://msdn.microsoft.com/en-us/library/ff877931.aspx QUESTION 62 You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. Some users must be prevented from deleting records in any of the tables in the Sales schema. You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort. What should you do? A.    Create a custom database role that includes the users. Deny Delete permissions on the Sales schema for the custom database role. B.    Include the Sales schema as an owned schema for the db_denydatawriter role. Add the users to the db_denydatawriter role. C.    Deny Delete permissions on each table in the Sales schema for each user. D.    Create a custom database role that includes the users. Deny Delete permissions on each table in the Sales schema for the custom database role. Answer: A QUESTION 63 You administer a Microsoft SQL Server 2012 database. The database has a table named Customers owned by UserA and another table named Orders owned by UserB. You also have a stored procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from both tables. You create a new user named UserC. You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need to assign only the minimum required permissions to UserC. Which permission or permissions should you assign to UserC? Choose all that apply. A.    The Select permission on Customers B.    The Execute permission on GetCustomerOrderInfo C.    The Take Ownership permission on Customers D.    The Control permission on GetCustomerOrderInfo E.    The Take Ownership permission on Orders F.    The Select permission on Orders Answer: AB Explanation: http://msdn.microsoft.com/en-us/library/ms188676.aspx http://stackoverflow.com/questions/2212044/sql-server-how-to-permission-schemas http://sqlservercentral.com/blogs/steve_jones/2012/03/14/ownership-chains-in-sql-server QUESTION 64 You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. Currently, Server01l/HA is the primary replica. You need to ensure that the following requirements are met: - Backup operations occur on Server02/HA. - If Server02/HA is unavailable, backup operations occur on Server03/HA. - Backup operations do not occur on Server01/HA. How should you configure HaContoso? A.    Set the backup preference of HaContoso to Prefer Secondary. Set the backup priority of Server02/HA to 20. Set the backup priority of Server03/HA to 10. B.    Set the backup preference of HaContoso to Secondary only. Set the backup priority of Server02/HA to 20. Set the backup priority of Server03/HA to 10. C.    Set the backup preference of HaContoso to Secondary only. Set the backup priority of Server02/HA to 10. Set the backup priority of Server03/HA to 20. D.    Set the exclude replica of Server01/HA to true. Set the backup priority of Server02/HA to 10. Set the backup priority of Server03/HA to 20. Answer: B Explanation: http://msdn.microsoft.com/en-us/library/ff877884.aspx http://msdn.microsoft.com/en-us/library/hh245119.aspx http://msdn.microsoft.com/en-us/library/hh710053.aspx QUESTION 65 Drag and Drop Question You 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 by using a stored procedure. - 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. Each data import command or recovery model may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.) Answer: Explanation: http://msdn.microsoft.com/en-us/library/ms162802.aspx http://msdn.microsoft.com/en-us/library/ms188365.aspx http://msdn.microsoft.com/en-us/library/ms175937.aspx http://msdn.microsoft.com/en-us/library/aa337544.aspx QUESTION 66 You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do? A.    Create SSIS configuration files for the packages. B.    Create an Integration Services catalog. C.    Install Data Quality Services. D.    Install Master Data services. Answer: B Explanation: http://msdn.microsoft.com/en-us/library/hh479588.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx QUESTION 67 You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales database is configured as shown in the following table. You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the minimum amount of time. What should you do? A.    Perform a restore from a full backup. B.    Perform a transaction log restore. C.    Perform a file restore. D.    Perform a filegroup restore. Answer: A Explanation: http://technet.microsoft.com/en-us/library/ms187048.aspx QUESTION 68 You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: A.    Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. B.    Perform a point-in-time restore. C.    Restore the latest full backup. D.    Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. E.    Restore the latest full backup. Then, restore the latest differential backup. F.    Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. G.    Perform a page restore. H.    Perform a partial restore. Answer: C QUESTION 69 You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: One of the hard disk drives that stores the reporting database fails at 16:40 hours. You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal. What should you do? A.    Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. B.    Perform a partial restore. C.    Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. D.    Restore the latest full backup. E.    Perform a page restore. F.    Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. G.    Restore the latest full backup. Then, restore the latest differential backup. H.    Perform a point-in-time restore. Answer: G QUESTION 70 You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database. You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal. What should you do? A.    Perform a partial restore. B.    Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. C.    Perform a point-in-time restore. D.    Restore the latest full backup. E.    Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. F.    Perform a page restore. G.    Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. H.    Restore the latest full backup. Then, restore the latest differential backup. Answer: F Lead2pass understand how important the certification exams are for your career development. Your brief overview with our Microsoft 70-458 exam packages, makes you acknowledged that our 70-458 exam products cover each and every thing related to exam curriculum. http://www.lead2pass.com/70-458.html --------------------------------------------------- Images: http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wps3C74.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wps7060.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wpsA5A4.tmp_thumb2_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wpsF06A.tmp_thumb2_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wps4D59.tmp_thumb_thumb.png http://www.itexamquiz.com/lead2pass/l2pimages/5e6d9c152dd8_949B/wpsA4EC.tmp_thumb2_thumb.png --------------------------------------------------- --------------------------------------------------- Post date: 2015-01-06 02:42:01 Post date GMT: 2015-01-06 02:42:01 Post modified date: 2015-01-06 02:42:01 Post modified date GMT: 2015-01-06 02:42:01 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com