dbt Labs dbt-Analytics-Engineering 問題集

質問 1：
You're setting up a new dbt project and want to customize the naming of compiled objects in the data warehouse. Which section of the dbt_project.yml file is the most relevant?
A. vars:
B. seeds:
C. snapshots:
D. models:
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You need to regularly run performance tests to benchmark a time-sensitive incremental model. These tests involve more complex setup than standard dbt tests. How could you efficiently integrate them into your workflow?
A. Define the performance tests as their own dbt project, triggered separately-
B. Write the tests as generic tests and use dbt's built-in warning thresholds.
C. Create a dbt operation (macro) to encapsulate the test logic and invoke it as needed.
D. Convert them into dbt seeds to easily execute them alongside model runs-
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You want to display the runtime metrics (e.g., execution time) of each model directly on the DAG node. Which challenges might you face when implementing this?
A. Adding too much detailed information directly to the DAG could lead to visual clutter and make it overwhelming.
B. dbt documentation is primarily static; it might not be able to render dynamic metrics that change with each execution.
C. Retrieving runtime metrics for each historical run might not be natively supported by dbt
D. All of the above
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You discover that dbt models create objects with the default database user's permissions. However, a policy mandates that analytics objects must be owned by a dedicated, less privileged account. How could you adapt your dbt workflow?
A. Configure the target database to automatically assign desired ownership to new objects in the schema
B. Implement pre-hooks or post-hooks to execute ALTER OWNER statements after model creation.
C. Modify your dbt profile to use the less privileged account's credentials during job execution.
D. Write dbt macros that contain permission management logic as part of the model deployment.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have a dbt macro that generates a list of models to execute dynamically. Which dbt command should you use in conjunction with this macro to actually run those models?
A. dbt parse to pre-compile the project graph, allowing model selection by reference.
B. dbt Is to retrieve project metadata and feed it into your custom execution logic.
C. dbt debug to step through model execution while using the macro's output
D. dbt build to create a task graph, extracting model nodes, and running them as needed.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A colleague has introduced a new sensitive column into a source table. You need to update the dbt project documentation accordingly. Which of the following actions should you take?
A. Consult your organization's data governance policies and consider additional measures beyond simple documentation.
B. Update the source documentation and add references to that documentation in the appropriate model's YAML file
C. Add a clear description of the sensitive column in its corresponding YAML file.
D. Add the column description and tag it using a custom sensitive tag in the YAML file.
正解：A,B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Your fct_orders model depends on both raw_sales and stg_customers. Due to upstream changes, the customer_id column in raw_sales is now named cust_id. How could you manage this change with minimal disruption?
A. Update the fct_orders model to reference cust_id.
B. Use a dbt source to rename the column in raw sales.
C. Utilize dbt's ref() function to dynamically adapt to the new column name.
D. Create an alias for customer_id as cust_id in the stg_customers model.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Your dbt project contains sensitive dat
a. You need to load seed data (e.g., lookup tables) while ensuring it's not accidentally committed to version control. How can you best achieve this?
A. Create separate seed files and add them to your .gitignore or equivalent.
B. Employ a secrets management tool and integrate it with your dbt deployment.
C. Utilize environment variables to store seed data values.
D. Write the seed data into log files, excluding them from version control.
正解：A
解説: (Topexam メンバーにのみ表示されます)