You need to design the solution for the government planning department.
Which services should you include in the design?
You need to design the solution for the government planning department.
Which services should you include in the design?
For the government planning department scenario, Azure Synapse Analytics and PolyBase are the most appropriate services to include in the design. Azure Synapse Analytics is capable of handling large-scale data integration, warehousing, and analytics, which are necessary for combining traffic data with other datasets, such as events, weather, and population statistics. PolyBase is ideal for querying relational and non-relational data, such as CSV files in Azure Data Lake Storage Gen2 and on-premises SQL Server 2016 databases. PolyBase allows seamless integration and analysis of the diverse data sources mentioned in the scenario.
External data used during the modeling is stored in on-premises SQL Server 2016 databases and CSV files stored in an Azure Data Lake Storage Gen2 storage account. Answer is B
Keep in mind that this data will be modeled and served, that leans towards Synapse Analytics and Polybase since there are external sources
Correct DYMIZE is right. SO ITS C 10000%
Data Lake is not supported with neither Azure SQL Database or onpremise SQL Server.
Answer is C