Question

Pick the right statement A. Data Lakes are used when you need a cheap way to store different types of data in large quantities B. Data marts offer isolated security but not isolated performance C. Data warehouse usually stores data directly which isn’t modelled yet D. Relational Databases could even hold unrelated data

Answer 1

ANSWER : The correct statement is-

OPTION (B): Data Lakes are used when you need a cheap way to store different types of data in large quantities.

REASONs:

• The data lake is a centralized repository that allows you to store all of your structured and unstructured data at any scale. Query results getting faster using low-cost storage (Cheap).
• The main purpose of a data mart is to isolate or separate a smaller dataset from the whole to make it easier for end users to access the data. Therefore, Data marts also offer isolated performance along with the isolated security.
• In Data Warehouse the data structure and schema are predefined to be optimized for fast SQL queries, the results of which are typically used for online reporting and analysis. Data is cleansed, enriched and transformed so that it can act as a “single source of truth” that users can trust. Therefore, data warehouse stores data which is modelled and structured.
• A relational database organizes data in the form of tables (or relationships). The table consists of rows and columns. Therefore, relational DB only holds related data.

If you are satisfied by my answer please give a thumbs up. Thank you.