下載最新試用版
1105位客戶反饋
我們對我們的產品非常有信心，所以我們不提供会给客户带去麻煩的產品。
dbt Labs dbt-Analytics-Engineering 考試概覽:
| 認證廠商: | dbt Labs |
| 考試名稱: | dbt分析工程師認證考試 |
| 考試代碼: | dbt-Analytics-Engineering |
| 證照有效期限: | 2年 |
| 及格分數: | 65% |
| 實際考試題數: | 65 |
| 支援語言: | 英文 |
| 考試時間: | 120 minutes |
| 考試形式: | 單選題, 線上監考 |
| 相關認證: | dbt架構師認證 |
| 考試費用: | 200 美元 |
| 推薦課程: | dbt認證考試準備指南 dbt官方技術文件 |
| 考試報名: | 官方報名頁面 |
| 範例考題: | dbt Labs dbt-Analytics-Engineering 範例考題 |
| 考試方式: | 線上遠端監考；透過Caveon測驗平台執行考試 |
| 必備條件: | 建議具備SQL操作能力；建議擁有6個月以上dbt Core或dbt Cloud實務經驗；無強制性報考門檻 |
| 官方大綱網址: | https://www.getdbt.com/certifications/analytics-engineer-certification-exam |
dbt Labs dbt-Analytics-Engineering 考試大綱主題:
| 章節 | 權重 | 目標 |
|---|---|---|
| 主題 1: 除錯與問題解決 | 15% | - 解決資料品質問題 - 辨識建模錯誤 - 除錯技巧 |
| 主題 2: 運用dbt狀態機制 | 5% | - 狀態管理 - 依狀態執行操作 |
| 主題 3: 實作dbt測試 | 10% | - 自訂測試 - 內建測試 - 測試設定與執行 |
| 主題 4: 外部相依性 | 10% | - 管理快照 - 整合外部來源資料 - 使用套件 |
| 主題 5: 開發dbt模型 | 20% | - 模型設計與架構
|
| 主題 6: 建立與維護文件 | 10% | - 說明與中繼資料 - 產生文件 - 文件製作標準 |
| 主題 7: dbt模型治理 | 15% | - 命名規範與標準 - 版本控制整合 - 專案組織與架構 |
| 主題 8: 管理資料管線 | 15% | - CI/CD整合 - 管線協調調度 - 部署策略 |
最新的 Analytics Engineers dbt-Analytics-Engineering 免費考試真題：
1. You're considering adding workflow orchestration to manage dependencies between your dbt project, data loading tasks, and the triggering of downstream Bl updates. Which of the following types of tools would be most suitable for this?
A) Data quality monitoring tools
B) Data lineage tools
C) CI/CD platforms
D) General-purpose workflow orchestration tools (e.g., Airflow, Prefect)
2. A model fails with an error similar to:Numeric overflow converting to data type numeric(18,2)
A) A timeout issue caused by the model exceeding resource limits.
B) Data within a column exceeding the precision or scale of the defined data type
C) Incorrect ref() usage causing cyclical dependencies to occur-
D) Missing permissions to write data to the target table in the warehouse.
3. You've just added some schema tests to a critical model. Which command should you execute to ensure these new tests are run?
A) dbt compile
B) dbt seed
C) dbt run
D) dbt test
4. A model passes its tests during development, but later fails when deployed on a less powerful production database. Which of the following might be the reason for this discrepancy?
A) The test was accidentally disabled in the production dbt project.
B) There's a bug in the version of dbt that runs in production.
C) Source data distributions differ significantly between environments.
D) Performance-related test thresholds are too lenient in development.
5. You introduce a minor formatting change to a large SQL model. Afterwards, the results change unexpectedly. Which dbt-related issue might explain this, even if the SQL itself appears correct?
A) A subtle indentation change in a CTE accidentally modifies the execution order within the query.
B) You've used a reserved keyword as a column alias without properly quoting it.
C) There's a version mismatch between the dbt library used during development and in production.
D) An upstream data issue only surfaces due to the formatting change making that part of the query execute differently.
問題與答案：
| 問題 #1 答案： D | 問題 #2 答案： B | 問題 #3 答案： D | 問題 #4 答案： C,D | 問題 #5 答案： A |
5.68.213.* -
我沒有去上我的dbt Labs認證考試課，但是，我買了VCESoft網站的學習資料，我使用它為了我最新dbt-Analytics-Engineering認證考試，真的是太高興了，我通過了考試，并獲得了證書，這是一個非常不錯的學習資料！