dbt Labs dbt Analytics Engineering Certification - dbt-Analytics-Engineering FREE EXAM DUMPS QUESTIONS & ANSWERS
You want to configure dbt to prevent tests from running if one or more of their parent models is unselected.
Which test command should you execute?
Choose 1 option.
Which test command should you execute?
Choose 1 option.
Correct Answer: B
Vote an answer
A user reports a critical security issue discovered in a third-party dbt package you use. Where could you most likely find updated information about potential vulnerabilities or fixes?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You've defined several source models using .yml files within your models directory. When you run dbt compile, they don't appear in the DAG visualization. What's the MOST likely cause?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You've configured your project to include both schema and data tests in the generated documentation. A user reports the tests are visible but don't show any execution results (pass/fail status). Why might this be happening?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
(Multiple Select)
Correct Answer: B,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You're experimenting with new transformations. You want to iterate on a model without affecting data in the production warehouse. Which dbt command should you use along with appropriate flags?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A dbt deployment pipeline fails on the production environment, yet everything works as intended in development and staging. Which areas would you investigate when troubleshooting?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You're onboarding a new dbt project to an existing production database. You find tables that might conflict with naming conventions used by dbt. What's a proactive way to handle this?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Your team decides to strictly enforce a linear history on the main branch. How does this decision impact your development and merge workflow?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You're tasked with adding functionality to your dbt project for:
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You need to run a dbt job that performs a long-running data cleansing operation. The job occasionally times out. Which of the following are potential solutions?
Correct Answer: A,B,C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You're working with a development data warehouse meant to closely mirror production. To make code more portable between environments, you opt to use environment variables for connection details. What's the best way to manage these?
Correct Answer: A,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
A project stakeholder requests access to an intermediate stage of a dbt transformation pipeline to validate specific calculations.
You need to weigh this request carefully because:
You need to weigh this request carefully because:
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You encounter the following error when running dbt compile:Runtime Error in model customer _ churn (models/transformations/customer_churn.sql)
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
(Multiple Select)
Correct Answer: A,B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).