Online Access Free 070-764 Practice Test

You are a database administrator for a Microsoft SQL Server 2016 environment.
You want to deploy a new application that will scale out the workload to at least five different SQL Server instances.
You need to ensure that for each copy of the database, users are able to read and write data that will then be synchronized between all of the database instances.
Which feature should you use?

• A.Peer-to-Peer Replication
• B.Log Shipping
• C.Database Mirroring
• D.Availability Groups

You are designing a database for a university.
The database will contain two tables named Classes and Enrollment that have the following specifications:
* Classes will store brochures in the XPS format. The brochures must be structured in folders and must be accessible by using UNC paths.
* Enrollment will store information about students and their classes. Performance must be enhanced for queries of the current enrollments.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies should you identify? To answer, drag the appropriate technology to the correct table in the answer area.

Correct Answer:

Explanation

The FileTable feature brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. FileTable lets an application integrate its storage and data management components, and provides integrated SQL Server services including full-text search and semantic search-over unstructured data and metadata. In other words, you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications.

You need to address the requirements for disc usage monitoring for the SQL Servers.
What should you do?

• A.You should configure alerts sent by the SQL Server Agent.
• B.You should configure a SQL Server Maintenance Plan.
• C.You should configure disc quotas.
• D.You should configure a Dynamic Management View.

You manage a Microsoft-SQL Server database named sales Orders.
You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database.
How should you complete the DBCC command? To answer, select the appropriate options in the answer area.

Correct Answer:

Explanation

Box 1: CHECKDB
DBCC CHECKDB checks the logical and physical integrity of all the objects in the specified database.
Partial syntax:
DBCC CHECKDB
[ ( database_name | database_id | 0
[ , NOINDEX
| , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
....
Box 2: REPAIR_REBUILD
DBCC CHECKDB ...REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST |REPAIR_REBUILD specifies that DBCC CHECKDB repair the found errors.
REPAIR_REBUILD performs repairs that have no possibility of data loss. This can include quick repairs, such as repairing missing rows in non-clustered indexes, and more time-consuming repairs, such as rebuilding an index.
References: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql

You administer a Microsoft SQL Server 2016 failover cluster.
You need to ensure that a failover occurs when the server diagnostics returns query_processing error.
Which server configuration property should you set?

• A.SqlDumperDumpPath
• B.FailureConditionLevel
• C.SqlOumperDumpFlags
• D.HealthCheckTimeout