~/dbtlabs-analytics-engineer-certification-exam · study ▊

practice sheet · all objectives switch to smart practice →

dbt Analytics Engineering Certification Exam

0/34 checked

Q_01 domain/d1 · medium single discuss →

An analytics engineering team is building semantic models to standardize company metrics. According to the workshop guidance, which three building blocks must they configure within their semantic models before they can define and use metrics effectively?

A Entities, dimensions, and measures
B Sources, seeds, and snapshots
C Models, tests, and macros
D Exposures, groups, and contracts

Q_02 domain/d1 · medium single discuss →

A team is transforming raw ERP extracts (SAP, Oracle ERP Cloud, Dynamics 365) into reporting models in dbt. Based on the described best practices, what is the primary goal of building this dbt layer on top of the ERP system of record?

A To replace the ERP system as the transactional system of record
B To transform raw ERP extracts into governed, tested, analytics-ready models
C To move business logic out of dbt and back into spreadsheets
D To disable version control so ERP data can be edited manually

Q_03 domain/d1 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_04 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_05 domain/d1 · hard single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_06 domain/d1 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_07 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_08 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_09 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_10 domain/d2 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_11 domain/d2 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_12 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_13 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_14 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_15 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_16 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_17 domain/d3 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_18 domain/d4 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_19 domain/d4 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_20 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_21 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_22 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_23 domain/d4 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_24 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_25 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_26 domain/d5 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_27 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_28 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_29 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_30 domain/d6 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_31 domain/d7 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_32 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_33 domain/d7 · medium multi

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

Q_34 domain/d7 · medium single

Locked question — unlock this exam to view it.

🔒 locked — unlock to review

32 questions locked

unlock all 32 questions