← Back to exam page

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

Loading demo links...

Showing 4–6 of 15 questions

Question 4 (Volume B)

You are planning to install a Microsoft SQL Server Database Engine instance. The instance will be used to support a high-volume OLTP database application.

The server has the following logical disk configuration. Drive C is used as the system drive:

Drive C: RAID 1

Drive D: RAID 10 Drive E: RAID 5

You need to ensure that the default data folders for the Database Engine are configured for optimal performance.

Which three actions should you perform? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    Place the User database log files on Drive D.
  • ○

    Place the TempDB data files and TempDB log files on Drive D.
  • ○

    Place the User database data files on Drive E.
  • ○

    Place the TempDB data files on Drive C.
  • ○

    Place the User Database log files on Drive C.
  • ○

    Place the TempDB log files on Drive E.
Question 5 (Volume B)

You administer a Microsoft SQL Server instance.

You need to configure a new database to support FILETABLES.

Which three actions should you perform? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    Disable FILESTREAM on the Database.
  • ○

    Enable FILESTREAM on the Server Instance.
  • ○

    Configure the Database for Partial Containment.
  • ○

    Create a non-empty FILESTREAM file group.
  • ○

    Enable Contained Databases on the Server Instance.
  • ○

    Set the FILESTREAM directory name on the Database.
Question 6 (Volume B)

You administer a database that has User A, B and C.

User A must be able to create new tables and stored procedures, User B must be able to select, update, delete and insert data.

User C must be able to provide windows logins to the database.

To which role or roles should you add the users?

Select all that apply, then click Submit answer.

  • ○

    db_accessadmin
  • ○

    db_ddladmin
  • ○

    db_datawriter
  • ○

    db_datareader
  • ○

    db_owner