October 27, 11:59 PM ISTOct 27, 11:59 PM IST
September 30, 2:52 AM ISTSep 30, 2:52 AM IST
1 left (3 attempts every 24 hours)
1 hour per attempt1h per attempt
1 left (1 total within the time limit)
To pass you need at least 80%. We keep your highest score.
Graded Assignment • 30 min
Which of the following serving methods is best for serving large files of semi-structured or unstructured data?
Nice job! Object storage or data lakes are suitable for serving large files of semi-structured or unstructured data.
What is one advantage of using a data sharing platform?
A data sharing platform helps you manage version control, ensuring a coherent and consistent version for the files you share with your end users.
Which of the following is a benefit of serving data directly from OLAP databases and data warehouses?
Great work! OLAP databases impose order and structure on the data by enforcing a schema.
What’s the purpose of a semantic layer that sits on top of your data model?
That’s right! Formally declaring data definitions and data logic in the semantic layer helps your end users more easily understand, navigate, and use the data.
How can you create a semantic layer that sits on top of your data model? (select the two answers that apply)
That’s right! You can use BI tools like Apache Superset and Looker to create a semantic layer.
Nice job! dbt can be used to create a semantic layer by defining standard business metrics using YAML files and SQL queries.
What is a key difference between a view and a materialized view?
A materialized view does some or all of the computations in advance, caches the results, and allows periodic refreshes. Views need to be executed every time the view is referenced.
What is a key difference between a view and a common table expression (CTE)?
A view is a database object that’s stored in the database and can be reused, whereas a CTE is temporary and only exists within the query that defines it.
What is one way a view can be used to enhance data security?
A view can be used to restrict access by selecting only specific columns and rows.
When thinking like a data engineer, what is the first step you should take when starting a new data project?
The first step in the framework for thinking like a data engineer is to identify the needs of your stakeholders and how they will derive value from the data.
