Exam 70-764 topic 1 question 60 discussion

Actual exam question from Microsoft's 70-764

Question #: 60
Topic #: 1

You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured.
The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server.
You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections.
What should you do?

A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server.
B. Execute the following Transact-SQL command: sp_configure 'remote admin connections',
C. Execute the Reconfigure command.
D. Execute the following Transact-SQL command: sp_configure 'remote access', 1
E. Restart the SQL Server Agent Service.
F. Enable inbound connections on TCP port 135 in the Windows Firewall on the server.

Show Suggested Answer

Suggested Answer: ABC 🗳️
SQL Server provides a dedicated administrator connection (DAC). The DAC lets an administrator access a running server to execute diagnostic functions or
Transact-SQL statements, or to troubleshoot problems on the server, even when the server is locked or running in an abnormal state and not responding to a SQL
Server Database Engine connection. By default, the DAC is only available from a client on the server. To enable client applications on remote computers to use the DAC, use the remote admin connections option of sp_configure.
By default, the DAC only listens on the loop-back IP address (127.0.0.1), port 1434
The following example enables the DAC from a remote computer. sp_configure 'remote admin connections', 1;

GO -
RECONFIGURE;

GO -
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/remote-admin-connections-server-configuration-option

by TheSwedishGuy at Jan. 24, 2020, 1:24 p.m.

Comments

Submit Cancel

DudeHere

Highly Voted 5 years, 1 month ago

MRN0107 A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. B. SHOULD be: sp_configure 'remote admin connections', 1; C. execute RECONFIGURE GO

upvoted 6 times

...

mrn0107

Most Recent 5 years, 3 months ago

Again wrong answer. 1. You need to enable inbouned connection on TCP 1434 port for DAC. 2. Execute sp_configure 'remote access', 1 (remote admin connection do not have "1" at the end so it will not make a change), 3. execute reconfigure

upvoted 4 times

Zikato

4 years, 3 months ago

You should use remote admin connections, even though the answer is copied without the '1'. This topic is about the "Remote Access" feature. This configuration option is an obscure SQL Server to SQL Server communication feature that is deprecated, and you probably shouldn't be using it

upvoted 1 times

...

TheSwedishGuy

5 years, 3 months ago

Trick question, you need to perform 3 steps.

upvoted 3 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam