Exam PL-600 topic 1 question 25 discussion

Although I would use Azure Data Lake the question clearly states that the solution must support the current data warehouse so the intention is to not replace it. Its Data Gateway: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem. The second answer is PowerBI. They want to display the report in Teams so the executives can see/use it. MT integration object isn't a solution on its own. Its a method to an end so-to-speak so I wouldn't choose that one.

It says right in the question that the current data warehouse already handles normalization and storage. They just need to be able to access it from the cloud, which is where data gateway comes in. 1-Data Gateway 2-Power BI

Data Gateway Power BI

Azure datalake and power BI

Based on ChatGPT: Feature Azure Data Gateway Azure Data Lake Purpose Connect on-premises data to the cloud Cloud-based big data storage solution

Data Gateway & Power BI

I understood the scenario like this: Old data: an on-premises data warehouse and analytics solution -> to be kept for seven years, then turn off. No migration just access the data. New Data in the Data Verse. Current analytics bring both sources together. After 7 Years all data is on data verse only.

IF you are planning to use azure analytical services then you'd need a Data Gateway which makes the answer incomplete.

The correct answer is 1-Data Gateway-Data Gateway can also be used to transform data before it's sent to cloud services, which is particularly useful for scenarios like data integration and data preparation so it does normalize data. 2-Power BI

Data Gateway & Power BI: It specifically states keeping using and supporting the existing data warehouse, which is doing the data storage and normalization. it doesn't say to move those abilities somewhere, it says to keep using this, so you need to use the Data Gateway and Power BI to make these requirements happen as Power BI needs the gateway. If it said replace then I would say data lake and power bi, but it doesn't. Also the Teams integration object isn't correct, it's not talking about the type of data from Power BI for filtering etc. You need to simply embed Power BI into Teams to meet the requirement

to meet the requirements of the company, you can recommend using Azure Analysis Services for data storage and Power BI for visibility to key operational metrics from various teams channel. Azure Analysis Services can be used to support the current data warehouse and retain at least seven years of historical data. Power BI can be used to provide analytical information to executives in a Microsoft Teams channel to support business planning Azure Analysis and Power bi

Chat GPT suggests: Neither Azure Data Lake nor Data Gateway is specifically designed for data storage and normalization of multi-dimensional data cubes. Instead, you should recommend using Azure Analysis Services, which is a fully managed platform as a service (PaaS) offering that can connect to the existing data warehouse and support drill-through capabilities into the data. Azure Analysis Services can also retain at least seven years of historical data and provides a scalable and cost-effective solution for data storage and normalization. Additionally, to provide analytical information to executives in a Microsoft Teams channel, you can recommend using Power BI, which is a part of the Microsoft Power Platform. Power BI can connect to Azure Analysis Services and can be embedded within Microsoft Teams to support business planning.

solution must support drill through capabilities in data, go for Power BI exposed on teams channels to show the key metrics that will provide the capability to drill through on a data

1. Azure Data Lake 2. Power BI

It's sort of a trick question because the optimal architecture wouldn't actually involve Power Platform. Data Lake is the appropriate storage and normalization engine. Which forces Power BI to be the answer to question 2 for visibility (even if Teams integration object is better). This is one of those tricks, where you have to choose Power Platform approach based on wording of requirement.

1st box: Azure Data Lake. Yes, a Data Gateway would likely be needed as part of the solution. However, this doesn't provide "Data storage or normalization"; neither does Dataverse for Teams. Azure Analysis Services is not a service used for "data storage"; not normalization either really. This leaves Azure Data Lake. Yes, it can certainly store data and be normalized. 2nd box: Power BI. Regarding Microsoft Teams Integration object: This a feature used in a Canvas App. It provides the ability for the Canvas App to be aware from which Teams channel the user is using the app from. This also means, that the app is embedded into a Teams channel. The app could have an embedded Power BI report. Potentially, this allows for a Power BI metric to be filtered according to the Team Channel the user is viewing the app from. However, this does not meet the requirement "Visibility to key operational metrics from various Teams channels". PowerBI is the main player here in my opinion.

1 - Data Gateway 2- Power BI as per Icky, Azure Data Lake would replace the current warehouse system.