15 Data Connectivity questions from the Power BI bank, written for Indian campus drives and tech interviews. Every question has a verified answer and an AI-tutor explanation on placd.
Free to start: the 2-minute IT readiness check — six questions and a result.
A.a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
B.a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
C.a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
D.a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
Answer + AI explanation with Pro
2. Which term means: "a storage method that loads and compresses a copy of source data into the in-memory model for fast querying"?
Junior
A.Import mode
B.Composite model
C.DirectQuery
D.Dual storage mode
Answer + AI explanation with Pro
3. Which statement is correct?
Junior
A.Import mode — a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.Import mode — a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
C.Import mode — a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
D.Import mode — a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
Answer + AI explanation with Pro
4. What is DirectQuery?
Mid
A.a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
C.a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
D.a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
Answer + AI explanation with Pro
5. Which term means: "a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows"?
Mid
A.Import mode
B.DirectQuery
C.Live connection
D.Composite model
Answer + AI explanation with Pro
6. Which statement is correct?
Mid
A.DirectQuery — a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.DirectQuery — a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
C.DirectQuery — a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
D.DirectQuery — a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
Answer + AI explanation with Pro
7. What is Live connection?
Mid
A.a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
B.a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
C.a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
D.a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
Answer + AI explanation with Pro
8. Which term means: "a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model"?
Mid
A.DirectQuery
B.Import mode
C.Live connection
D.Dual storage mode
Answer + AI explanation with Pro
9. Which statement is correct?
Mid
A.Live connection — a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
B.Live connection — a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
C.Live connection — a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
D.Live connection — a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
Answer + AI explanation with Pro
10. What is Composite model?
Senior
A.a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
C.a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
D.a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
Answer + AI explanation with Pro
11. Which term means: "a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime"?
Senior
A.Import mode
B.Composite model
C.Live connection
D.DirectQuery
Answer + AI explanation with Pro
12. Which statement is correct?
Senior
A.Composite model — a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.Composite model — a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
C.Composite model — a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
D.Composite model — a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
Answer + AI explanation with Pro
13. What is Dual storage mode?
Senior
A.a storage method that leaves data at the source and sends a query to it for every visual interaction instead of caching rows
B.a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
C.a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
D.a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
Answer + AI explanation with Pro
14. Which term means: "a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source"?
Senior
A.Dual storage mode
B.Live connection
C.Composite model
D.Import mode
Answer + AI explanation with Pro
15. Which statement is correct?
Senior
A.Dual storage mode — a table setting that lets an engine choose at query time whether to serve cached rows or push the request to the source
B.Dual storage mode — a method that connects directly to an existing Analysis Services or shared dataset model without building a separate local model
C.Dual storage mode — a storage method that loads and compresses a copy of source data into the in-memory model for fast querying
D.Dual storage mode — a single model that mixes imported tables and remote tables so some data is cached while other data is queried at runtime
Answer + AI explanation with Pro
Free to start
Start with a free readiness check
Sign up free for the 2-minute IT readiness check and a scored result. Answers, explanations and the AI tutor on every Data Connectivity question come with Pro.