Use read-only replicas to offload read-only query workloads.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

There is only one control node, that is considered the brain of Azure Synapse Analytics. The control node is responsible to run the MPP Engine and optimizes queries. MPP Engine distributes processing across compute nodes. The number of compute nodes can be between 1 to 60.
Option A is incorrect. The MPP Engine of the Azure Synapse Analytics runs on the control node and can't redirect client connections across a single control node. Moreover, there is no redirection of client connections.
Option B is correct. The MPP Engine of the Azure Synapse Analytics runs on the control node and distributes processing across compute nodes.
Option C is incorrect. The MPP Engine of the Azure Synapse Analytics runs on the control node and can't distribute processing across a single control node.
Option D is incorrect. The MPP Engine of the Azure Synapse Analytics does not redirect client connections to compute nodes as there is no redirection of client connections.
Reference: To know more about the Massively Parallel Processing (MPP), refer to the documentation below from Azure:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/massively-parallel- processing-mpp-architecture

Given statements are for the different services for the Azure data warehouse and data workloads.
Except for statement 1, all other statements are true only. But Azure Analytics services provide enterprise-level data models in the cloud. It is used to combine data from different data sources, define the metrics, and secure all the data in a single, trusted tabular semantic data model.
Option A is correct. Statements 2, 3, and 4 are true while statements 1 is wrong.
Option B is incorrect. Statement 1 is wrong here, and statement 4 that is true is missing.
Option C is incorrect. Statement 1 is wrong here, and statement 2 that is true is missing.
Option D is incorrect. Statement 1 is wrong here, and statement 3 that is true is missing.
Option E is incorrect. All 4 statements are not true; statement 1 is wrong.
Reference: To know more, check out the links below:
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-overview
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-overview-what-is
https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
https://docs.microsoft.com/en-us/azure/data-factory/introduction