Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 5 of 134
Free Preview · 134 of 444 · questions 1–134 of 444 are free. Sign up free to sync your progress across devices.
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Option to use to combine the Customer tables: Since you want one combined table but keep your original queries intact (to support scheduled refresh and avoid model bloat), the best choice is to use Append Queries as New. Action to perform on the original two SQL database queries: If you load all three (both sources and the combined table) into the data model, you’ll triple your model size. To minimise the model size, you keep the original queries as connections only (not loaded to the model).
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Combine the Customer tables: Append Queries as New Explanation: Appending creates a single combined table from both sources without duplicating columns, minimizing model size. Action on the original queries: Disable loading to the data model Explanation: Prevents unnecessary tables from being loaded, reducing memory usage and improving performance while still supporting scheduled refresh.
Option to use to combine the Customer tables: Since you want one combined table but keep your original queries intact (to support scheduled refresh and avoid model bloat), the best choice is to use Append Queries as New. Action to perform on the original two SQL database queries: If you load all three (both sources and the combined table) into the data model, you’ll triple your model size. To minimise the model size, you keep the original queries as connections only (not loaded to the model).
Correct answer