← Back to exam page

70-462 – Administering Microsoft SQL Server 2012/2014 Databases

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Volume B)

You administer a Microsoft SQL Server 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. The database is configured to use the FULL recovery model.

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? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    Create a LOG backup every 5 minutes.
  • ○

    Configure the database to use the SIMPLE recovery model.
  • ○

    Create a DIFFERENTIAL database backup every 4 hours.
  • ○

    Create a DIFFERENTIAL database backup every 24 hours.
  • ○

    Create a FULL database backup every 24 hours.
Question 8 (Volume B)

You administer a Microsoft SQL Server 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 UserA. 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? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    The Select permission on Customers
  • ○

    The Execute permission on GetCustomerOrderInfo
  • ○

    The Take Ownership permission on Customers
  • ○

    The Control permission on GetCustomerOrderInfo
  • ○

    The Take Ownership permission on Orders
  • ○

    The Select permission on Orders
Question 9 (Volume B)

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 three.

Select all that apply, then click Submit answer.

  • ○

    Configure the database to use the SIMPLE recovery model.
  • ○

    Create a DIFFERENTIAL database backup every 4 hours.
  • ○

    Create a LOG backup every 5 minutes.
  • ○

    Configure the database to use the FULL recovery model.
  • ○

    Create a FULL database backup every 24 hours.
  • ○

    Create a DIFFERENTIAL database backup every 24 hours.