Microsoft 70-765 Provisioning SQL Databases Online Training
Microsoft 70-765 Online Training
The questions for 70-765 were last updated at Dec 20,2024.
- Exam Code: 70-765
- Exam Name: Provisioning SQL Databases
- Certification Provider: Microsoft
- Latest update: Dec 20,2024
You administer a Microsoft SQL Server 2014 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 at17: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 at08: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.
You administer a Microsoft SQL Server 2014 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.
Latest 70-765 Dumps Valid Version with 243 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
