Online Access Free 70-765 Practice Test

You have database that contains a 400-GB table that is read-only.
You need to enable the Stretch Database feature.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Correct Answer:

Explanation:
Section: Deploy and migrate applications
To configure an existing table for Stretch Database, run the ALTER TABLE command.
Here's an example that migrates the entire table and begins data migration immediately.
USE <Stretch-enabled database name>;
GO
ALTER TABLE <table name>
SET ( REMOTE_DATA_ARCHIVE = ON ( MIGRATION_STATE = OUTBOUND ) ) ;
GO
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-atable

You administer a Microsoft SQL Server 2014 failover cluster that contains two nodes named Node A and Node B.
A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.
What should you do?

• A.Run the New SQL Server stand-alone installation Wizard on Node C.
• B.Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
• C.Use Node A to install SQL Server on Node C.
• D.Use Node B to install SQL Server on Node C.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in an Always On Availability Group. You expect to have less than 1 million IO transaction per month.
You need to recommend a storage solution for the SQL Servers. The solution must minimize costs.
Which storage option should you use?

• A.Standard zone redundant blob storage
• B.Premium P30 disk storage
• C.Standard locally redundant blob storage
• D.Premium P10 disk storage
• E.Standard geo-redundant disk storage
• F.Standard geo-redundant blob storage
• G.Standard locally redundant disk storage
• H.Premium P20 disk storage

You have a database named DB1 that is 3 TB. obi contains a fact table that is 1.2 TB.
You load 200 GB of new data to the fact table from a line-of-business application.
Users of DB1 notice that reports render more slowly since you loaded the data.
What are two possible causes of the performance issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.out-of-date statistics
• B.transaction log growth
• C.index fragmentation
• D.page corruption

You administer a Microsoft SQL Server 2016 instance.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.

• A.Enable Contained Databases on the Server Instance.
• B.Disable FILESTREAM on the Database.
• C.Create a non-empty FILESTREAM file group.
• D.Set the FILESTREAM directory name on the Database.
• E.Enable FILESTREAM on the Server Instance.
• F.Configure the Database for Partial Containment.