exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 10 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 10
[All DP-201 Questions]

HOTSPOT -
You need to design network access to the SQL Server data.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: 8080 -
1433 is the default port, but we must change it as CONT_SQL3 must not communicate over the default ports. Because port 1433 is the known standard for SQL
Server, some organizations specify that the SQL Server port number should be changed to enhance security.
Box 2: SQL Server Configuration Manager
You can configure an instance of the SQL Server Database Engine to listen on a specific fixed port by using the SQL Server Configuration Manager.
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017
Design for data security and compliance

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Nits0211
Highly Voted 5 years ago
It seems the title of the boxes are swapped. Box 1 should be SQL Server Network Configuration Port and Box 2 should be Tool
upvoted 21 times
thukza
5 years ago
Yes you are right.
upvoted 3 times
...
...
Mandar77
Most Recent 3 years, 12 months ago
Question is ambiguous as there are 3 SQL databases having SQL data. which one are they talking about?
upvoted 1 times
...
AngelRio
4 years ago
I think is SSMS and 1433 port
upvoted 1 times
...
PasswordPassword
4 years, 10 months ago
SQL Server listens on port 1433
upvoted 4 times
Ikrom
4 years, 9 months ago
8080 because of this: "CONT_SQL3 must not communicate over the default ports".
upvoted 14 times
chakanirban
3 years, 11 months ago
AZURE SQL DB not SQL VM
upvoted 1 times
...
...
anamaster
4 years, 1 month ago
and 1433 is the default for sql server
upvoted 2 times
...
...
pravinDataSpecialist
4 years, 11 months ago
yes that confused me a little .. boxes should be swapped and the question will make sense
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...