Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
A table named recent_orders is created with the following code:
CREATE TABLE recent_orders AS (
SELECT a.user_id, a.email, b.order_id, b.order_date
FROM
(SELECT user_id, email
FROM users) a
INNER JOIN
(SELECT user_id, order_id, order_date
FROM orders
WHERE order_date > (current_date() - 7)) b
ON a.user_id = b.user_id
)
Both users and orders are Delta Lake tables. What describes the results when querying recent_orders?
A table named recent_orders is created with the following code:
CREATE TABLE recent_orders AS (
SELECT a.user_id, a.email, b.order_id, b.order_date
FROM
(SELECT user_id, email
FROM users) a
INNER JOIN
(SELECT user_id, order_id, order_date
FROM orders
WHERE order_date > (current_date() - 7)) b
ON a.user_id = b.user_id
)
Both users and orders are Delta Lake tables. What describes the results when querying recent_orders?
Exam-Like