Which of the following describes the relationship between Gold tables and Silver tables?
A. Gold tables are more likely to contain more data than Silver tables.
B. Gold tables are more likely to contain aggregations than Silver tables.
C. Gold tables are more likely to contain valuable data than Silver tables.
D. Gold tables are more likely to contain truthful data than Silver tables.
E. Gold tables are more likely to contain a less refined view of data than Silver tables.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.
Which of the following approaches can the data engineer use to set up the new task?
A. They can clone the existing task in the existing Job and update it to run the new notebook.
B. They can create a new task in the existing Job and then add the original task as a dependency of the new task.
C. They can create a new task in the existing Job and then add it as a dependency of the original task.
D. They can clone the existing task to a new Job and then edit it to run the new notebook.
E. They can create a new job from scratch and add both tasks to run concurrently.
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results.
Which of the following approaches can the manager use to ensure the results of the query are updated each day?
A. They can schedule the query to run every 12 hours from the Jobs UI.
B. They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
C. They can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
D. They can schedule the query to run every 1 day from the Jobs UI.
E. They can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.
Which of the following commands can be used to grant full permissions on the database to the new data engineering team?
A. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
B. GRANT ALL PRIVILEGES ON TABLE team TO sales;
C. GRANT SELECT ON TABLE sales TO team;
D. GRANT USAGE ON TABLE sales TO team;
E. GRANT ALL PRIVILEGES ON TABLE sales TO team;
正解:E
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
A data engineer only wants to execute the final block of a Python program if the Python variable day_of_week is equal to 1 and the Python variable review_period is True.
Which of the following control flow statements should the data engineer use to begin this conditionally executed code block?
A. if day_of_week = 1 and review_period:
B. if day_of_week = 1 & review_period: = "True":
C. if day_of_week == 1 and review_period == "True":
D. if day_of_week == 1 and review_period:
E. if day_of_week = 1 and review_period = "True":
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
久本** -
本日Databricks-Certified-Data-Engineer-Associate試験を受けました。合格できました。
購入した問題集の問題が多数出てました。本当に役に立ちました。
ありがとうございました。