Databricks-Certified-Data-Engineer-Associate Exam Dumps | A data engineer is transforming a Bronze table containing API-response data into a Silver table. The

<< Prev Question Next Question >>

Question 81/111

A data engineer is transforming a Bronze table containing API-response data into a Silver table. The Bronze table has a user_profile column of type STRING that contains JSON dat a. An example value is:
{"user_id":"12345","name":"John Smith","age":32,"email":"[email protected]"} The Silver table must make this data easily queryable for analytics without requiring JSON parsing in every downstream query.
Which approach standardizes this column for the Silver table?

A. SELECT
from_json(
user_profile,
'user_id STRING, name STRING, age STRING, email STRING'
) AS parsed_profile
FROM bronze_table;

B. SELECT
user_profile.user_id AS user_id,
user_profile.name AS name,
CAST(user_profile.age AS INT) AS age,
user_profile.email AS email
FROM bronze_table;

C. SELECT
get_json_object(user_profile, '$.user_id') AS user_id,
get_json_object(user_profile, '$.name') AS name,
CAST(get_json_object(user_profile, '$.age') AS INT) AS age,
get_json_object(user_profile, '$.email') AS email
FROM bronze_table;

D. SELECT
get_json_object(user_profile, 'user_id') AS user_id,
get_json_object(user_profile, 'name') AS name,
get_json_object(user_profile, 'age') AS age,
get_json_object(user_profile, 'email') AS email
FROM bronze_table;

Question 81/111

LEAVE A REPLY

Download PDF File