DA-100 Dataset Practice Questions
The free DA-100: Analyzing Data with Microsoft Power BI questions that deal with dataset, with answers and explanations. The full bank and the timed practice test cover every topic the exam asks about.
Question #5
You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh. From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity. You discover that the dataset refresh fails after the refresh runs out of resources. What is a possible cause of the issue?
Correct answer: A
Explanation
The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called “query folding”. It is not recommended that incremental refresh is used when the required query folding cannot take place. Reference: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/
Question #6
You have the following three versions of an Azure SQL database: Test Production Development You have a dataset that uses the development database as a data source. You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com. Which should you do?
Correct answer: C
Explanation
https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/4-development-lifecycle-s
Continue with DA-100: Analyzing Data with Microsoft Power BI
Unlock the full question bank
You have read the first 10 questions. A subscription opens every question in DA-100: Analyzing Data with Microsoft Power BI, the full timed practice test, and your progress and weak-topic reporting.
Single exam
$19.99for 30 days
Full question bank and practice test for one exam, for 30 days.
Single exam
$49.99for 1 year
One exam for a full year. Nothing renews and nothing to cancel.
Full access
$39.99/mo
Every exam in the catalogue, month to month.
Full access
$199.99/yr
Every exam in the catalogue for a year.
Already subscribed? Sign in to pick up where you left off.
All DA-100: Analyzing Data with Microsoft Power BI practice questions →