Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
What is the minimum number of datasets and storage modes required to support the reports?
Solved! Go to Solution.
SharePoint and Dynamics 365 Business Central don't support Direct queries, SO not B nor C. And if we choose import mode, "an Import model can integrate data from any number of supported data source types"(https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand). So the answer is D.
Thank u so much
You are welcome :), please mark the question as the correct answer so that it can help others as well
Ritesh
SharePoint and Dynamics 365 Business Central don't support Direct queries, SO not B nor C. And if we choose import mode, "an Import model can integrate data from any number of supported data source types"(https://docs.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand). So the answer is D.
1. Even one table within a sheet is enough to start with/ One Data-source with One Table
2. You set the Storage mode property to one of these three values: (so the answer is One)
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be fulfilled only from cached data.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset—for example, DAX queries—and that return data from DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that you submit to the data source use the query language for that data source, for example, SQL.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In other cases, you fulfill queries by executing an on-demand query to the data source.
What is the minimum number of datasets and storage modes required to support the reports?
A . two imported datasets
B . a single DirectQuery dataset
C . two DirectQuery datasets
D . a single imported dataset
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
101 | |
82 | |
79 | |
66 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |