1. What is Import mode ? Junior 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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