Exam 70-765 topic 3 question 10 discussion

HOTSPOT -

Background -
You manage a Microsoft SQL Server environment that includes the following databases: DB1, DB2, Reporting.
The environment also includes SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS). All SSRS and SSAS servers use named instances.
You configure a firewall rule for SSAS.

Databases -
Database Name:

DB1 -
Notes:
This database was migrated from SQL Server 2012 to SQL Server 2016. Thousands of records are inserted into DB1 or updated each second. Inserts are made by many different external applications that your company's developers do not control. You observe that transaction log write latency is a bottleneck in performance. Because of the transient nature of all the data in this database, the business can tolerate some data loss in the event of a server shutdown.
Database Name:

DB2 -
Notes:
This database was migrated from SQL Server 2012 to SQL Server 2016. Thousands of records are updated or inserted per second. You observe that the
WRITELOG wait type is the highest aggregated wait type. Most writes must have no tolerance for data loss in the event of a server shutdown. The business has identified certain write queries where data loss is tolerable in the event of a server shutdown.
Database Name:

Reporting -
Notes:
You create a SQL Server-authenticated login named BIAppUser on the SQL Server instance to support users of the Reporting database. The BIAppUser login is not a member of the sysadmin role.
You plan to configure performance-monitoring alerts for this instance by using SQL Agent Alerts.
You need to open the firewall ports for use with SQL Server environment.
In table below, identify the firewall port that you must use for each service.
NOTE: Make only one selection in each column.
Hot Area:

Suggested Answer:
Report Server: 80 -
By default, the report server listens for HTTP requests on port 80.
Incorrect Answers:
Not 1433: If you are accessing SQL Server relational databases on external computers, or if the report server database is on an external SQL Server instance, you must open port 1433 and 1434 on the external computer. In this scenario there is no mention of an external server.
SQL Server Browser service for SSAS: 1433

How SQL Server Browser Works -
When an instance of SQL Server starts, if the TCP/IP protocol is enabled for SQL Server, the server is assigned a TCP/IP port. If the named pipes protocol is enabled, SQL Server listens on a specific named pipe. This port, or "pipe," is used by that specific instance to exchange data with client applications. During installation, TCP port 1433 and pipe \sql\query are assigned to the default instance,
References:

https://msdn.microsoft.com/en-us/library/bb934283.aspx
https://technet.microsoft.com/en-us/library/ms181087(v=sql.130).aspx