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

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

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: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
ThomasReps
Highly Voted 1 year, 5 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 11 times
...
vctrhugo
Highly Voted 1 year, 2 months 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 8 times
...
Harman30
Most Recent 2 weeks, 5 days ago
Selected Answer: B
B. A data lakehouse supports ACID-compliant transactions.
upvoted 1 times
...
9d4d68a
3 months ago
B. A data lakehouse supports ACID-compliant transactions. ACID compliance (Atomicity, Consistency, Isolation, Durability) ensures that transactions are processed reliably and helps maintain data integrity. This feature allows for reliable updates, deletions, and insertions in a data lakehouse, which significantly improves data quality by avoiding issues like partial updates or inconsistent states that are common in traditional data lakes.
upvoted 1 times
...
80370eb
3 months, 2 weeks ago
Selected Answer: B
B. A data lakehouse supports ACID-compliant transactions. ACID compliance ensures data integrity and consistency, which improves the overall quality of the data.
upvoted 1 times
...
ranjan24
4 months, 1 week ago
answer is B
upvoted 1 times
...
mascarenhaslucas
5 months, 2 weeks ago
Selected Answer: B
The answer is B!
upvoted 1 times
...
bm.bala.murugan.sb
6 months, 1 week ago
Selected Answer: B
B is Correct
upvoted 1 times
...
benni_ale
7 months ago
Selected Answer: B
b is correct as acid transactions are related to data quality
upvoted 1 times
...
benni_ale
7 months, 3 weeks ago
Selected Answer: B
b is correct
upvoted 2 times
...
Itmma
8 months, 1 week ago
Selected Answer: B
B is correct
upvoted 1 times
...
SerGrey
10 months, 3 weeks ago
Selected Answer: B
Correct andwer is B
upvoted 1 times
...
Garyn
11 months ago
Selected Answer: B
B. A data lakehouse supports ACID-compliant transactions. ACID (Atomicity, Consistency, Isolation, Durability) compliance ensures that transactions are processed reliably and consistently, which is crucial for maintaining data integrity and quality. It helps in preventing data inconsistencies or errors that might occur during concurrent transactions or data operations. By supporting ACID-compliant transactions, a data lakehouse can enhance data quality by providing mechanisms to ensure the reliability and consistency of data operations, which is a notable improvement over traditional data lakes that might lack such transactional capabilities.
upvoted 2 times
...
Huroye
1 year ago
point of correction: B is the correct answer, not A as posted in my previous comment
upvoted 1 times
...
Huroye
1 year 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 year ago
Selected Answer: B
Correct : B
upvoted 1 times
...
VijayKula
1 year, 1 month ago
Selected Answer: B
Acid Transaction is the correct answer
upvoted 1 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 ...