Infosys Certified Data Build Tool Developer
Practice with real exam-pattern questions for Infosys Certified Data Build Tool Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Data Build Tool Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Data Build Tool Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What are some common mistakes that developers make while configuring the profiles.yml file in dbt Core?
- ✓Use hard-coded values instead of environment variablesCorrect
- BNeglect to externalize sensitive information
- CFail to document configuration changes
- DAll of the given options
- Question 2
Which materialization type do dbt models default to if none is explicitly specified?
- ✓TableCorrect
- BView
- CEphemeral
- DIncremental
- Question 3
In a profiles.yml file for dbt Core, you have the following configuration:
my_project: target: dev outputs: dev: type: snowflake account: my_snowflake_account user: dbt_user password: dbt_password role: dbt_role database: my_database warehouse: my_warehouse schema: public prod: type: snowflake account: prod_snowflake_account user: dbt_prod_user password: prod_password role: prod_role database: prod_database warehouse: prod_warehouse schema: analyticsWhich of the following statements is true regarding the configuration in the profiles.yml file?
- ✓The dev target will use the analytics schema in a database namely my_databaseCorrect
- BThe prod target will connect to a Snowflake account named my_snowflake_account
- CThe prod target will use the public schema in a database named prod_database
- DThe dev target will connect to a Snowflake warehouse named my_warehouse
- Question 4
You are setting up dbt Core and need to ensure that the profiles.yml file is correctly located for dbt to recognize it.
Which of the following statements is true regarding the location of the profiles.yml file?- ✓The profiles.yml file must be located in the ~/.dbt/ directoryCorrect
- BThe profiles.yml file can be located in any directory as long as the DBT_PROFILES_DIR environment variable is set to that directory
- CBoth options are correct
- DNone of the options
- Question 5
You have the following dbt_project.yml configuration for your dbt project:
name: my_dbt_project version: 1.0.0 config-version: 2 profile: my_project source-paths: ["models"] analysis-paths: ["analyses"] test-paths: ["tests"] data-paths: ["data"] macro-paths: ["macros"] snapshot-paths: ["snapshots"] target-path: "target" clean-targets: ["target", "dbt_modules"] models: my_dbt_project: materialized: table staging: materialized: view marts: materialized: incrementalWhich of the following statements is true regarding the configuration in the dbt_project.yml file?
- ✓The source-paths configuration specifies the directory where dbt will look for SQL files defining modelsCorrect
- BThe analysis-paths configuration specifies the directory where dbt will store compiled SQL files
- CThe test-paths configuration specifies the directory where dbt will look for data files
- DThe macro-paths configuration specifies the directory where dbt will store snapshots
- Question 6
Which of the following is a valid mean by which ELT systems enhance data quality?
- ✓By including data cleansing stepsCorrect
- BBy skipping data validation steps
- CBy reducing data transformation
- DBy limiting data extraction
- Question 7
What does "dbt" stand for?
- ✓Data Building ToolCorrect
- BData Built-in Tool
- CData Build Tool
- DData Builder Tool
- Question 8
Which of the following is NOT a best practice in dbt?
- ✓Using the ref function to manage dependencies between modelsCorrect
- BRenaming and type casting of fields in the staging layer
- CDirectly referencing source table data in the model
- DWriting tests for your models to ensure data quality
- Question 9
Where is the default location for the profiles.yml file if it is not found in the current working directory?
- ✓/etc/dbt/Correct
- B~/.dbt/
- C/usr/local/dbt/
- D~/dbt/
- Question 10
Which of the following databases is NOT supported by dbt?
- ✓SnowflakeCorrect
- BDatabricks
- CPostgreSQL
- DMongoDB
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.