Data ETL Lakehouse Basics MCQ Questions with Answers – Page 2 (Latest 2026)

Q51. Which statement about schema evolution is most accurate?

A. Add/modify columns without rewriting all data. B. Pure manual migrations. C. Schema is frozen. D. Always re-ingest.

Select an answer to check.

Answer: Add/modify columns without rewriting all data.

Here, Add/modify columns without rewriting all data. is the right choice. Forward/backward compat. It aligns directly with what the question asks about which statement about schema evolution is most accurate. Competing choices sound plausible, but they miss the key condition.

Q52. How is schema evolution best characterized?

A. Pure manual migrations. B. Schema is frozen. C. Add/modify columns without rewriting all data. D. Always re-ingest.

Select an answer to check.

Answer: Add/modify columns without rewriting all data.

In this case, Add/modify columns without rewriting all data. is correct. Forward/backward compat. It aligns directly with what the question asks about how is schema evolution best characterized. Competing choices sound plausible, but they miss the key condition.

Q53. Which option best describes partition evolution (Iceberg)?

A. Always rewrite full table. B. No partitioning. C. Change partitioning without rewriting old data. D. Pure static partitioning.

Select an answer to check.

Answer: Change partitioning without rewriting old data.

The best option here is Change partitioning without rewriting old data.. Iceberg specialty. It aligns directly with what the question asks about which option best describes partition evolution (iceberg). Competing choices sound plausible, but they miss the key condition.

Q54. What is the primary purpose of partition evolution (Iceberg)?

A. No partitioning. B. Pure static partitioning. C. Change partitioning without rewriting old data. D. Always rewrite full table.

Select an answer to check.

Answer: Change partitioning without rewriting old data.

For this question, Change partitioning without rewriting old data. is correct. Iceberg specialty. It aligns directly with what the question asks about what is the primary purpose of partition evolution. Competing choices sound plausible, but they miss the key condition.

Q55. Which statement about partition evolution (Iceberg) is most accurate?

A. Change partitioning without rewriting old data. B. Pure static partitioning. C. Always rewrite full table. D. No partitioning.

Select an answer to check.

Answer: Change partitioning without rewriting old data.

Change partitioning without rewriting old data. is the correct answer here. Iceberg specialty. It aligns directly with what the question asks about which statement about partition evolution (iceberg) is most. Competing choices sound plausible, but they miss the key condition.

Q56. How is partition evolution (Iceberg) best characterized?

A. No partitioning. B. Change partitioning without rewriting old data. C. Pure static partitioning. D. Always rewrite full table.

Select an answer to check.

Answer: Change partitioning without rewriting old data.

Here, Change partitioning without rewriting old data. is the right choice. Iceberg specialty. This matches the core idea being tested around how is partition evolution (iceberg) best characterized. Competing choices sound plausible, but they miss the key condition.

Q57. Which option best describes file compaction?

A. Combine small files for performance. B. Always many small files. C. Pure deletes. D. Pure rewrites of single rows.

Select an answer to check.

Answer: Combine small files for performance.

In this case, Combine small files for performance. is correct. Reduces metadata overhead. This matches the core idea being tested around which option best describes file compaction. Competing choices sound plausible, but they miss the key condition.

Q58. What is the primary purpose of file compaction?

A. Always many small files. B. Pure rewrites of single rows. C. Pure deletes. D. Combine small files for performance.

Select an answer to check.

Answer: Combine small files for performance.

The best option here is Combine small files for performance.. Reduces metadata overhead. This matches the core idea being tested around what is the primary purpose of file compaction. Competing choices sound plausible, but they miss the key condition.

Q59. Which statement about file compaction is most accurate?

A. Combine small files for performance. B. Pure deletes. C. Pure rewrites of single rows. D. Always many small files.

Select an answer to check.

Answer: Combine small files for performance.

For this question, Combine small files for performance. is correct. Reduces metadata overhead. This matches the core idea being tested around which statement about file compaction is most accurate. Competing choices sound plausible, but they miss the key condition.

Q60. How is file compaction best characterized?

A. Combine small files for performance. B. Always many small files. C. Pure rewrites of single rows. D. Pure deletes.

Select an answer to check.

Answer: Combine small files for performance.

Combine small files for performance. is the correct answer here. Reduces metadata overhead. This matches the core idea being tested around how is file compaction best characterized. Competing choices sound plausible, but they miss the key condition.

Q61. Which option best describes z-ordering / clustering?

A. Random ordering. B. Pure indexing only. C. Co-locate related rows in files. D. Pure partitioning only.

Select an answer to check.

Answer: Co-locate related rows in files.

Here, Co-locate related rows in files. is the right choice. Improves selective scans. That is exactly the concept behind which option best describes z-ordering / clustering in this context. Competing choices sound plausible, but they miss the key condition.

Q62. What is the primary purpose of z-ordering / clustering?

A. Co-locate related rows in files. B. Pure partitioning only. C. Random ordering. D. Pure indexing only.

Select an answer to check.

Answer: Co-locate related rows in files.

In this case, Co-locate related rows in files. is correct. Improves selective scans. That is exactly the concept behind what is the primary purpose of z-ordering / in this context. Competing choices sound plausible, but they miss the key condition.

Q63. Which statement about z-ordering / clustering is most accurate?

A. Random ordering. B. Co-locate related rows in files. C. Pure indexing only. D. Pure partitioning only.

Select an answer to check.

Answer: Co-locate related rows in files.

The best option here is Co-locate related rows in files.. Improves selective scans. That is exactly the concept behind which statement about z-ordering / clustering is most in this context. Competing choices sound plausible, but they miss the key condition.

Q64. How is z-ordering / clustering best characterized?

A. Pure partitioning only. B. Pure indexing only. C. Random ordering. D. Co-locate related rows in files.

Select an answer to check.

Answer: Co-locate related rows in files.

For this question, Co-locate related rows in files. is correct. Improves selective scans. That is exactly the concept behind how is z-ordering / clustering best characterized in this context. Competing choices sound plausible, but they miss the key condition.

Q65. Which option best describes vacuum?

A. A pure schema change. B. A pure backup. C. A pure compaction. D. Remove old files past retention.

Select an answer to check.

Answer: Remove old files past retention.

Remove old files past retention. is the correct answer here. Required for cost control. That is exactly the concept behind which option best describes vacuum in this context. Competing choices sound plausible, but they miss the key condition.

Q66. What is the primary purpose of vacuum?

A. A pure compaction. B. Remove old files past retention. C. A pure schema change. D. A pure backup.

Select an answer to check.

Answer: Remove old files past retention.

Here, Remove old files past retention. is the right choice. Required for cost control. It fits the requirement in the prompt about what is the primary purpose of vacuum. Competing choices sound plausible, but they miss the key condition.

Q67. Which statement about vacuum is most accurate?

A. A pure schema change. B. A pure compaction. C. A pure backup. D. Remove old files past retention.

Select an answer to check.

Answer: Remove old files past retention.

In this case, Remove old files past retention. is correct. Required for cost control. It fits the requirement in the prompt about which statement about vacuum is most accurate. Competing choices sound plausible, but they miss the key condition.

Q68. How is vacuum best characterized?

A. Remove old files past retention. B. A pure backup. C. A pure schema change. D. A pure compaction.

Select an answer to check.

Answer: Remove old files past retention.

The best option here is Remove old files past retention.. Required for cost control. It fits the requirement in the prompt about how is vacuum best characterized. Competing choices sound plausible, but they miss the key condition.

Q69. Which option best describes CDC merge in lakehouse?

A. Pure append-only. B. Pure overwrite. C. Pure full reload. D. MERGE INTO target with key + LSN.

Select an answer to check.

Answer: MERGE INTO target with key + LSN.

For this question, MERGE INTO target with key + LSN. is correct. Apply changes idempotently. It fits the requirement in the prompt about which option best describes cdc merge in lakehouse. Competing choices sound plausible, but they miss the key condition.

Q70. What is the primary purpose of CDC merge in lakehouse?

A. Pure overwrite. B. Pure full reload. C. Pure append-only. D. MERGE INTO target with key + LSN.

Select an answer to check.

Answer: MERGE INTO target with key + LSN.

MERGE INTO target with key + LSN. is the correct answer here. Apply changes idempotently. It fits the requirement in the prompt about what is the primary purpose of cdc merge. Competing choices sound plausible, but they miss the key condition.

Q71. Which statement about CDC merge in lakehouse is most accurate?

A. Pure overwrite. B. MERGE INTO target with key + LSN. C. Pure append-only. D. Pure full reload.

Select an answer to check.

Answer: MERGE INTO target with key + LSN.

Here, MERGE INTO target with key + LSN. is the right choice. Apply changes idempotently. This is the most accurate statement for which statement about cdc merge in lakehouse is. Competing choices sound plausible, but they miss the key condition.

Q72. How is CDC merge in lakehouse best characterized?

A. Pure overwrite. B. Pure append-only. C. MERGE INTO target with key + LSN. D. Pure full reload.

Select an answer to check.

Answer: MERGE INTO target with key + LSN.

In this case, MERGE INTO target with key + LSN. is correct. Apply changes idempotently. This is the most accurate statement for how is cdc merge in lakehouse best characterized. Competing choices sound plausible, but they miss the key condition.

Q73. Which option best describes streaming + batch?

A. Pure stream only. B. Mix incremental and batch loads. C. Pure RPC. D. Pure batch only.

Select an answer to check.

Answer: Mix incremental and batch loads.

The best option here is Mix incremental and batch loads.. Lakehouse supports both. This is the most accurate statement for which option best describes streaming + batch. Competing choices sound plausible, but they miss the key condition.

Q74. What is the primary purpose of streaming + batch?

A. Pure RPC. B. Pure batch only. C. Pure stream only. D. Mix incremental and batch loads.

Select an answer to check.

Answer: Mix incremental and batch loads.

For this question, Mix incremental and batch loads. is correct. Lakehouse supports both. This is the most accurate statement for what is the primary purpose of streaming +. Competing choices sound plausible, but they miss the key condition.

Q75. Which statement about streaming + batch is most accurate?

A. Pure RPC. B. Pure stream only. C. Mix incremental and batch loads. D. Pure batch only.

Select an answer to check.

Answer: Mix incremental and batch loads.

Mix incremental and batch loads. is the correct answer here. Lakehouse supports both. This is the most accurate statement for which statement about streaming + batch is most. Competing choices sound plausible, but they miss the key condition.

Q76. How is streaming + batch best characterized?

A. Pure RPC. B. Mix incremental and batch loads. C. Pure batch only. D. Pure stream only.

Select an answer to check.

Answer: Mix incremental and batch loads.

Here, Mix incremental and batch loads. is the right choice. Lakehouse supports both. It aligns directly with what the question asks about how is streaming + batch best characterized. The remaining choices fail because they don’t satisfy the full definition.

Q77. Which option best describes optimize / compact commands?

A. Always avoid optimization. B. Pure backup. C. Run periodic optimization on tables. D. Pure index rebuild.

Select an answer to check.

Answer: Run periodic optimization on tables.

In this case, Run periodic optimization on tables. is correct. Schedule per workload. It aligns directly with what the question asks about which option best describes optimize / compact commands. The remaining choices fail because they don’t satisfy the full definition.

Q78. What is the primary purpose of optimize / compact commands?

A. Pure index rebuild. B. Run periodic optimization on tables. C. Always avoid optimization. D. Pure backup.

Select an answer to check.

Answer: Run periodic optimization on tables.

The best option here is Run periodic optimization on tables.. Schedule per workload. It aligns directly with what the question asks about what is the primary purpose of optimize /. The remaining choices fail because they don’t satisfy the full definition.

Q79. Which statement about optimize / compact commands is most accurate?

A. Always avoid optimization. B. Pure backup. C. Pure index rebuild. D. Run periodic optimization on tables.

Select an answer to check.

Answer: Run periodic optimization on tables.

For this question, Run periodic optimization on tables. is correct. Schedule per workload. It aligns directly with what the question asks about which statement about optimize / compact commands is. The remaining choices fail because they don’t satisfy the full definition.

Q80. How is optimize / compact commands best characterized?

A. Pure backup. B. Run periodic optimization on tables. C. Pure index rebuild. D. Always avoid optimization.

Select an answer to check.

Answer: Run periodic optimization on tables.

Run periodic optimization on tables. is the correct answer here. Schedule per workload. It aligns directly with what the question asks about how is optimize / compact commands best characterized. The remaining choices fail because they don’t satisfy the full definition.

Q81. Which option best describes change data feed?

A. Pure log only. B. Pure CDC at source. C. Read row-level changes from a Delta table. D. Pure backups.

Select an answer to check.

Answer: Read row-level changes from a Delta table.

Here, Read row-level changes from a Delta table. is the right choice. Streaming downstream consumers. This matches the core idea being tested around which option best describes change data feed. The remaining choices fail because they don’t satisfy the full definition.

Q82. What is the primary purpose of change data feed?

A. Pure backups. B. Read row-level changes from a Delta table. C. Pure CDC at source. D. Pure log only.

Select an answer to check.

Answer: Read row-level changes from a Delta table.

In this case, Read row-level changes from a Delta table. is correct. Streaming downstream consumers. This matches the core idea being tested around what is the primary purpose of change data. The remaining choices fail because they don’t satisfy the full definition.

Q83. Which statement about change data feed is most accurate?

A. Pure CDC at source. B. Read row-level changes from a Delta table. C. Pure log only. D. Pure backups.

Select an answer to check.

Answer: Read row-level changes from a Delta table.

The best option here is Read row-level changes from a Delta table.. Streaming downstream consumers. This matches the core idea being tested around which statement about change data feed is most. The remaining choices fail because they don’t satisfy the full definition.

Q84. How is change data feed best characterized?

A. Pure log only. B. Pure backups. C. Pure CDC at source. D. Read row-level changes from a Delta table.

Select an answer to check.

Answer: Read row-level changes from a Delta table.

For this question, Read row-level changes from a Delta table. is correct. Streaming downstream consumers. This matches the core idea being tested around how is change data feed best characterized. The remaining choices fail because they don’t satisfy the full definition.

Q85. Which option best describes multi-table transactions?

A. Pure no transactions. B. Pure best-effort. C. Per-table only. D. Atomic across multiple tables.

Select an answer to check.

Answer: Atomic across multiple tables.

Atomic across multiple tables. is the correct answer here. Limited support; varies by engine. This matches the core idea being tested around which option best describes multi-table transactions. The remaining choices fail because they don’t satisfy the full definition.

Q86. What is the primary purpose of multi-table transactions?

A. Pure no transactions. B. Pure best-effort. C. Atomic across multiple tables. D. Per-table only.

Select an answer to check.

Answer: Atomic across multiple tables.

Here, Atomic across multiple tables. is the right choice. Limited support; varies by engine. That is exactly the concept behind what is the primary purpose of multi-table transactions in this context. The remaining choices fail because they don’t satisfy the full definition.

Q87. Which statement about multi-table transactions is most accurate?

A. Pure no transactions. B. Per-table only. C. Pure best-effort. D. Atomic across multiple tables.

Select an answer to check.

Answer: Atomic across multiple tables.

In this case, Atomic across multiple tables. is correct. Limited support; varies by engine. That is exactly the concept behind which statement about multi-table transactions is most accurate in this context. The remaining choices fail because they don’t satisfy the full definition.

Q88. How is multi-table transactions best characterized?

A. Pure best-effort. B. Per-table only. C. Atomic across multiple tables. D. Pure no transactions.

Select an answer to check.

Answer: Atomic across multiple tables.

The best option here is Atomic across multiple tables.. Limited support; varies by engine. That is exactly the concept behind how is multi-table transactions best characterized in this context. The remaining choices fail because they don’t satisfy the full definition.

Q89. Which option best describes storage formats (Parquet)?

A. Columnar format with compression. B. CSV plain text. C. JSON only. D. XML only.

Select an answer to check.

Answer: Columnar format with compression.

For this question, Columnar format with compression. is correct. Backbone of lakehouses. That is exactly the concept behind which option best describes storage formats (parquet) in this context. The remaining choices fail because they don’t satisfy the full definition.

Q90. What is the primary purpose of storage formats (Parquet)?

A. Columnar format with compression. B. JSON only. C. XML only. D. CSV plain text.

Select an answer to check.

Answer: Columnar format with compression.

Columnar format with compression. is the correct answer here. Backbone of lakehouses. That is exactly the concept behind what is the primary purpose of storage formats in this context. The remaining choices fail because they don’t satisfy the full definition.

Q91. Which statement about storage formats (Parquet) is most accurate?

A. Columnar format with compression. B. JSON only. C. CSV plain text. D. XML only.

Select an answer to check.

Answer: Columnar format with compression.

Here, Columnar format with compression. is the right choice. Backbone of lakehouses. It fits the requirement in the prompt about which statement about storage formats (parquet) is most. The remaining choices fail because they don’t satisfy the full definition.

Q92. How is storage formats (Parquet) best characterized?

A. Columnar format with compression. B. JSON only. C. CSV plain text. D. XML only.

Select an answer to check.

Answer: Columnar format with compression.

In this case, Columnar format with compression. is correct. Backbone of lakehouses. It fits the requirement in the prompt about how is storage formats (parquet) best characterized. The remaining choices fail because they don’t satisfy the full definition.

Q93. Which option best describes metastore (Unity / Hive)?

A. Pure schema files. B. Pure logs only. C. Pure file system only. D. Catalog of tables and permissions.

Select an answer to check.

Answer: Catalog of tables and permissions.

The best option here is Catalog of tables and permissions.. Governance and discovery. It fits the requirement in the prompt about which option best describes metastore (unity / hive). The remaining choices fail because they don’t satisfy the full definition.

Q94. What is the primary purpose of metastore (Unity / Hive)?

A. Pure logs only. B. Pure file system only. C. Catalog of tables and permissions. D. Pure schema files.

Select an answer to check.

Answer: Catalog of tables and permissions.

For this question, Catalog of tables and permissions. is correct. Governance and discovery. It fits the requirement in the prompt about what is the primary purpose of metastore (unity. The remaining choices fail because they don’t satisfy the full definition.

Q95. Which statement about metastore (Unity / Hive) is most accurate?

A. Pure logs only. B. Pure file system only. C. Pure schema files. D. Catalog of tables and permissions.

Select an answer to check.

Answer: Catalog of tables and permissions.

Catalog of tables and permissions. is the correct answer here. Governance and discovery. It fits the requirement in the prompt about which statement about metastore (unity / hive) is. The remaining choices fail because they don’t satisfy the full definition.

Q96. How is metastore (Unity / Hive) best characterized?

A. Pure logs only. B. Catalog of tables and permissions. C. Pure file system only. D. Pure schema files.

Select an answer to check.

Answer: Catalog of tables and permissions.

Here, Catalog of tables and permissions. is the right choice. Governance and discovery. This is the most accurate statement for how is metastore (unity / hive) best characterized. The remaining choices fail because they don’t satisfy the full definition.

Q97. Which option best describes query engines?

A. Pure caching layer. B. Pure storage layer. C. Pure logging layer. D. Spark, Trino, Photon, etc.

Select an answer to check.

Answer: Spark, Trino, Photon, etc.

In this case, Spark, Trino, Photon, etc. is correct. Operate on lakehouse formats. This is the most accurate statement for which option best describes query engines. The remaining choices fail because they don’t satisfy the full definition.

Q98. What is the primary purpose of query engines?

A. Pure logging layer. B. Spark, Trino, Photon, etc. C. Pure caching layer. D. Pure storage layer.

Select an answer to check.

Answer: Spark, Trino, Photon, etc.

The best option here is Spark, Trino, Photon, etc.. Operate on lakehouse formats. This is the most accurate statement for what is the primary purpose of query engines. The remaining choices fail because they don’t satisfy the full definition.

Q99. Which statement about query engines is most accurate?

A. Pure caching layer. B. Pure storage layer. C. Pure logging layer. D. Spark, Trino, Photon, etc.

Select an answer to check.

Answer: Spark, Trino, Photon, etc.

For this question, Spark, Trino, Photon, etc. is correct. Operate on lakehouse formats. This is the most accurate statement for which statement about query engines is most accurate. The remaining choices fail because they don’t satisfy the full definition.

Q100. How is query engines best characterized?

A. Pure storage layer. B. Pure logging layer. C. Spark, Trino, Photon, etc. D. Pure caching layer.

Select an answer to check.

Answer: Spark, Trino, Photon, etc.

Spark, Trino, Photon, etc. is the correct answer here. Operate on lakehouse formats. This is the most accurate statement for how is query engines best characterized. The remaining choices fail because they don’t satisfy the full definition.