ACID — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. What are the four traits of ACID?
Question 1A. Atomicity, Consistency, Isolation and DurabilityB. Availability, Consistency, Integrity and DurabilityC. Atomicity, Concurrency, Isolation and DistributionD. Accuracy, Completeness, Integrity and DurabilityE. Atomicity, Consistency, Indexing and Durability
2. What does Atomicity guarantee?
Question 2A. That every query sees the latest committed valueB. That two users cannot update the same row at onceC. That data is completely written to the destination with no partial data left behindD. That data survives a machine failureE. That every table has a primary key
3. What does Consistency guarantee?
Question 3A. That writes are never lost after a crashB. That partial writes are rolled backC. That each user has a private copy of the dataD. That all data is stored in the same file formatE. That once an operation is performed, its results are visible to every subsequent query
4. What does Isolation guarantee?
Question 4A. That data is encrypted between nodesB. That an incomplete operation by one user does not cause unexpected side effects for other usersC. That every operation is written to a transaction logD. That queries run on a dedicated nodeE. That operations complete in the order submitted
5. What does Durability guarantee?
Question 5A. That the database can scale to petabytesB. That queries always return within a fixed timeC. That data is never duplicatedD. That once an operation is completed, it is preserved even if the machine or system failsE. That data can be read by every user simultaneously
6. The database Transaction Log, which holds every query statement run so that lost data can be reproduced, is given as an example of which ACID trait?
Question 6A. AtomicityB. DurabilityC. IsolationD. ConsistencyE. Availability
7. What is the relationship between ACID and Insert, Update and Delete operations?
Question 7A. ACID replaces the need for Insert, Update and DeleteB. Insert, Update and Delete are the four traits of ACIDC. ACID applies only to Select queriesD. ACID slows down Insert, Update and Delete so they should be avoidedE. ACID makes sure that while Insert, Update and Delete queries are happening, nothing impacts operational behaviour
8. How can ACID capability be achieved in Hadoop via Hive?
Question 8A. By using ORC or Parquet file formatsB. By using CSV or JSON file formatsC. By disabling the transaction logD. By storing data on tapeE. By using only structured data
9. How does Databricks provide ACID capability through Delta Lake?
Question 9A. Using HDFS with any file formatB. Using a relational database as a side storeC. Using its compute layer over HadoopD. Using only Object Storage and only the Parquet file formatE. Using in-memory tables
10. In a nutshell, what is said about Insert, Update and Delete functions without ACID?
Question 10A. They run fasterB. They are only available in NoSQL databasesC. They are not reliableD. They require Object StorageE. They cannot be logged