Do you want to pass Microsoft 70-458 Exam ? If you answered YES, then look no further. Braindump2go offers you the best 70-458 exam questions which cover all core test topics and certification requirements. All REAL questions and answers from Microsoft Exam Center will help you be a 70-458 certified!
Vendor: Microsoft
Exam Code: 70-458
Exam Name: Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2 Exam
QUESTION 71
You administer a Microsoft SQL Server 2012 instance.
The instance contains a database that supports a retail sales application.
The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week.
You plan to define a backup strategy for the database.
You need to ensure that the following requirements are met:
– No more than 5 minutes worth of transactions are lost.
– Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.
A. Configure the database to use the SIMPLE recovery model.
B. Create a DIFFERENTIAL database backup every 4 hours.
C. Create a LOG backup every 5 minutes.
D. Configure the database to use the FULL recovery model.
E. Create a FULL database backup every 24 hours.
F. Create a DIFFERENTIAL database backup every 24 hours.
Answer: BCDE
Explanation:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx
http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx
QUESTION 72
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 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are corrupted on the reporting database.
You need to ensure that the databases are 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. Restore the latest full backup.
D. Restore the latest full backup, and restore the latest differential backup.
Then, restore the latest log backup.
E. Perform a page restore.
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 point-in-time restore.
H. Restore the latest full backup. Then, restore the latest differential backup.
Answer: H
Explanation:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx
http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx
QUESTION 73
Drag and Drop Question
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application.
You need to migrate the database without affecting the production environment.
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:
Explanation:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx
http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx
QUESTION 74
You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database.
You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?
A. User mapped to a certificate
B. SQL user without login
C. SQL user with login
D. SQL user without login
E. User mapped to an asymmetric key
F. Login mapped to a virtual account
Answer: B
Explanation:
http://msdn.microsoft.com/en-us/library/ff929071.aspx
QUESTION 75
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database.
The database is backed up according to the following schedule:
– Daily full backup at 23:00 hours.
– Differential backups on the hour, except at 23:00 hours.
– Log backups every 10 minutes from the hour, except on the hour.
The database uses the Full recovery model. A developer accidentally drops a number of tables and stored procedures from the database between 22:40 hours and 23:10 hours.
You perform a database restore at 23:30 hours to recover the dropped table.
You need to restore the database by using the minimum amount of administrative effort.
You also need to ensure minimal data loss.
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:
Explanation:
http://msdn.microsoft.com/en-us/library/ms187048.aspx
http://msdn.microsoft.com/en-us/library/ms186289.aspx
http://msdn.microsoft.com/en-us/library/ms175477.aspx
http://msdn.microsoft.com/en-us/library/ms189860.aspx
http://msdn.microsoft.com/en-us/library/ms179314.aspx
http://msdn.microsoft.com/en-us/library/ms175526.aspx
http://msdn.microsoft.com/en-us/library/ms191539.aspx
http://msdn.microsoft.com/en-us/library/ms191429.aspx
http://msdn.microsoft.com/en-us/library/ms191253.aspx
QUESTION 76
Drag and Drop Question
You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1 and Node2.
Node 1 fails and the cluster fails over to Node 2.
You need to replace Node 1 and add it to the cluster.
Which four 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:
Explanation:
http://technet.microsoft.com/en-us/library/ms181075.aspx
QUESTION 77
Drag and Drop Question
You administer a Microsoft SQL Server instance.
You use a two-node SQL Server failover cluster.
Node B is primary, and Node A is secondary.
You need to install a security patch on both nodes.
You need to ensure that the following requirements are met:
– Both nodes receive the update.
– Downtime is minimized.
– No data is lost.
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:
Explanation:
http://technet.microsoft.com/en-us/library/ms191295.aspx
http://msdn.microsoft.com/en-us/library/ms191009.aspx
QUESTION 78
Drag and Drop Question
You administer a Microsoft SQL Server database.
Service accounts for SQL Agent are configured to use a local user.
A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job.
The SSIS package accesses a network share when exporting data from a SQL Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server.
You need to ensure that the SQL Server Agent job can execute the SSIS package.
Which four 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:
Explanation:
http://msdn.microsoft.com/en-us/library/ms175834.aspx
http://msdn.microsoft.com/en-us/library/ms189522.aspx
http://msdn.microsoft.com/en-us/library/ms190703.aspx
http://msdn.microsoft.com/en-us/library/ms161950.aspx
QUESTION 79
You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size.
The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours.
Users modify more than 30 percent of the data in the database during the week.
Backups are performed as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours.
This batch process will take a maximum of 8 hours to complete.
The batch process will update three tables that are 10 GB in size.
The batch process will update these tables multiple times.
When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly.
You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time.
What should you do on Saturday?
A. Perform a differential backup at 08:59 hours.
B. Record the LSN of the transaction log at 08:59 hours.
Perform a transaction log backup at 17:01 hours.
C. Create a database snapshot at 08:59 hours.
D. Record the LSN of the transaction log at 08:59 hours.
Perform a transaction log backup at 08:59 hours.
E. Create a marked transaction in the transaction log at 08:59 hours.
Perform a transaction log backup at 17:01 hours.
F. Create a marked transaction in the transaction log at 08:59 hours.
Perform a transaction log backup at 08:59 hours.
Answer: C
QUESTION 80
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database.
All database traffic to the SQL Server must be encrypted by using secure socket layer (SSL) certificates or the connection must be refused.
Network administrators have deployed server certificates to the Windows store of all Windows servers ortn the network from a trusted Ceificate Authority.
This is the only Certificate Authority allowed to distribute certificates on the network.
You enable the Force Encryption flag for the MSSQLServer protocols, but client computers are unable to connect.
They receive the following error message:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake, (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server)"
You notice the following entry in the SQL Server log:
"A self-generated certificate was successfully loaded for encryption."
You need to configure SQL Server to encrypt all client traffic across the network.
You also need to ensure that client computers are able to connect to the server by using a trusted certificate.
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:
Explanation:
http://thesqldude.com/2012/04/21/setting-up-ssl-encryption-for-sql-server-using-certificates- issues-tips-tricks/
Want to be 70-458 certified? Using Braindump2go New Released 70-458 Exam Dumps Now! We Promise you a 100% Success Passing Exam 70-458 Or We will return your money back instantly!