Power BI Data Connectivity and Data Sources Flashcards
7 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Power BI Data Connectivity and Data Sources flashcards as text
What is the fundamental difference between Import mode and DirectQuery mode in Power BI?
Answer: Import caches data in Power BI's in-memory engine; DirectQuery queries the source at render time
Import mode loads and compresses data into Power BI's in-memory VertiPaq engine, while DirectQuery forwards each visual's query to the source system in real time.
Which Power BI feature allows a single dataset to include tables from both Import and DirectQuery storage modes?
Answer: Composite Models
Composite Models enable a single Power BI dataset to combine tables using Import and DirectQuery storage modes, including connections to multiple data sources.
In Power BI Composite Models, what does 'Dual' storage mode mean for a table?
Answer: The table behaves as Import or DirectQuery depending on which is more efficient for the query
A table in Dual storage mode is cached locally like an Import table but can also be queried live like a DirectQuery table, allowing the engine to choose the most efficient path.
Which built-in Power BI connector is specifically designed to connect to Salesforce CRM data?
Answer: Salesforce Objects connector
Power BI includes a native Salesforce Objects connector that authenticates directly with Salesforce and exposes its standard and custom objects as tables.
What is the maximum dataset size supported in a Power BI Pro shared workspace?
Answer: 1 GB
Power BI Pro workspaces cap individual dataset sizes at 1 GB, whereas Power BI Premium capacity supports up to 100 GB or more per dataset.
Which gateway type is required to support scheduled refresh from an on-premises SQL Server in a shared Power BI Service workspace?
Answer: Standard (Enterprise) On-premises Data Gateway
The Standard (Enterprise) On-premises Data Gateway is required for shared workspaces to refresh on-premises SQL Server data; the Personal gateway cannot be shared across an organization.
In Power BI Desktop, what happens when you click 'Transform Data' instead of 'Load' after selecting a data source?
Answer: Power Query Editor opens so you can clean and shape the data before loading
Clicking 'Transform Data' opens the Power Query Editor, which provides a full environment for filtering, cleaning, and reshaping data before it enters the Power BI data model.