Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam Certified Data Engineer Associate topic 1 question 9 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 9
Topic #: 1
[All Certified Data Engineer Associate Questions]

Which of the following data lakehouse features results in improved data quality over a traditional data lake?

  • A. A data lakehouse provides storage solutions for structured and unstructured data.
  • B. A data lakehouse supports ACID-compliant transactions.
  • C. A data lakehouse allows the use of SQL queries to examine data.
  • D. A data lakehouse stores data in open formats.
  • E. A data lakehouse enables machine learning and artificial Intelligence workloads.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Huroye
3 weeks, 5 days ago
point of correction: B is the correct answer, not A as posted in my previous comment
upvoted 1 times
...
Huroye
3 weeks, 5 days ago
A is the correct answer. Allowing SQL query to examine data does not improve the quality of the data. For example, if the person writes the wrong query they will get a wrong answer. So how does that improve the quality of the data?
upvoted 1 times
...
awofalus
1 month ago
Selected Answer: B
Correct : B
upvoted 1 times
...
VijayKula
2 months ago
Selected Answer: B
Acid Transaction is the correct answer
upvoted 1 times
...
KalavathiP
2 months, 2 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
d_b47
2 months, 2 weeks ago
Selected Answer: B
ACID is the correct ans.
upvoted 1 times
...
vctrhugo
3 months, 1 week ago
Selected Answer: B
B. A data lakehouse supports ACID-compliant transactions. One of the key features of a data lakehouse that results in improved data quality over a traditional data lake is its support for ACID (Atomicity, Consistency, Isolation, Durability) transactions. ACID transactions provide data integrity and consistency guarantees, ensuring that operations on the data are reliable and that data is not left in an inconsistent state due to failures or concurrent access. In a traditional data lake, such transactional guarantees are often lacking, making it challenging to maintain data quality, especially in scenarios involving multiple data writes, updates, or complex transformations. A data lakehouse, by offering ACID compliance, helps maintain data quality by providing strong consistency and reliability, which is crucial for data pipelines and analytics.
upvoted 3 times
...
hany_ds
4 months ago
B is correct answer. Only B deals with data quality i.e. ACID transactions make sure all the transactions are complete, isolated, consistent and durable.
upvoted 1 times
...
mehroosali
5 months, 1 week ago
Selected Answer: B
B is correct
upvoted 2 times
...
ThomasReps
6 months ago
Selected Answer: B
Option B - ACID Properties Source: https://www.databricks.com/blog/2021/08/30/frequently-asked-questions-about-the-data-lakehouse.html#five -> "Lakehouse tackles the fundamental issues that make data swamps out of data lakes. It adds ACID transactions to ensure consistency as multiple parties concurrently read or write data."
upvoted 4 times
...
Bishtu
6 months ago
Selected Answer: B
ACID capabilities
upvoted 1 times
...
Majjjj
7 months, 1 week ago
Selected Answer: B
ACID-compliant transactions ensure that data is consistent, reliable, and accurate. By supporting ACID transactions, a data lakehouse can provide improved data quality over a traditional data lake. This is because ACID transactions guarantee that updates to the data are either completed in their entirety or not at all, reducing the risk of data corruption or errors.
upvoted 2 times
...
Varma_Saraswathula
7 months, 3 weeks ago
Option B - Acid Properties
upvoted 1 times
...
naxacod574
7 months, 3 weeks ago
Option B, Acid compliant
upvoted 1 times
...
sdas1
8 months, 1 week ago
Option B
upvoted 1 times
...
knivesz
8 months, 1 week ago
Selected Answer: B
ACID properties
upvoted 3 times
...
surrabhi_4
8 months, 1 week ago
Selected Answer: B
Option B, Delta Lake supports ACID properties. Data lake do not support ACID properties.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...