← Back to exam page

70-764 – Administering a SQL Database Infrastructure

Loading demo links...

Showing 7–9 of 20 questions

Question 7

You administer a Microsoft SQL Server 2012 instance.

You need to configure a new database to support FILETABLES.

What should you do? Choose all that apply.

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 8

You maintain three datacenters in different geographical regions. You have a four-node failover cluster that hosts a Microsoft SQL Server Failover Cluster Instance (FCI) in Datacenter1.

You must extend FCI to add four nodes in Datacenter2.

You need to configure a node majority quorum mode for the cluster.

What are the two possible ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Use a cloud quorum witness that is hosted in Microsoft Azure
  • ○

    Use no witness
  • ○

    Use a disk witness that is hosted in Datacenter2
  • ○

    Use a disk witness that is hosted in Datacenter1
  • ○

    Use a file share witness that is hosted in Datacenter3
Question 9

You have a Microsoft SQL Server instance that has a database named DB1. The database is used for reporting purposes. You plan to capture all queries for a specific table and save the data as a text file.

You need to ensure that queries are captured and that a failure to capture a query will shut down the SQL Server instance.

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

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    Enable SQL Server Audit.
  • ○

    Use Extended Events.
  • ○

    Use a logon trigger.
  • ○

    Create a SQL Server Profiler trace and disable c2 audit tracing.
  • ○

    Enable SQL Server Query Store.