Practice Free Databricks Certified Data Analyst Associate Exam Online Questions
Which of the following is a benefit of the Databricks Lakehouse Platform embracing open source technologies?
- A . Cloud-specific integrations
- B . Simplified governance
- C . Ability to scale storage
- D . Ability to scale workloads
- E . Avoiding vendor lock-in
After running DESCRIBE EXTENDED accounts.customers;, the following was returned:
Now, a data analyst runs the following command:
DROP accounts.customers;
Which of the following describes the result of running this command?
- A . Running SELECT * FROM delta. `dbfs:/stakeholders/customers` results in an error.
- B . Running SELECT * FROM accounts.customers will return all rows in the table.
- C . All files with the .customers extension are deleted.
- D . The accounts.customers table is removed from the metastore, and the underlying data files are deleted.
- E . The accounts.customers table is removed from the metastore, but the underlying data files are untouched.
What describes the variance of a set of values?
- A . Variance is a measure of how far a single observed value is from a set ot va IN
- B . Variance is a measure of how far an observed value is from the variable’s maximum or minimum value.
- C . Variance is a measure of central tendency of a set of values.
- D . Variance is a measure of how far a set of values is spread out from the sets central value.
Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?
- A . Use Workflows to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
- B . Use Delta Live Tables to establish a cluster for Fivetran to interact with
- C . Use Partner Connect’s automated workflow to establish a cluster for Fivetran to interact with
- D . Use Partner Connect’s automated workflow to establish a SQL warehouse (formerly known as a SQL endpoint) for Fivetran to interact with
- E . Use Workflows to establish a cluster for Fivetran to interact with
A BI analyst is building an analytical data model in Databricks using Delta Lake tables. The source system contains transactional sales data that changes frequently. The analyst chooses to apply the Data Vault 2.0 methodology to manage historical changes while ensuring scalability and auditability across multiple business domains.
Which component is used to capture the many-to-many relationship between hubs in a Data Vault v2 model?
- A . Hub Table
- B . Satellite Table
- C . Link Table
- D . Reference Table
A Data Analyst is working on sensor_df; this DataFrame contains two columns: record_datetime timestamp and record array.
Which code fragment returns a DataFrame that splits the record column into separate columns and has one array item per row?
- A . Uses withColumn, but selects sensor_id, status, and health as if they are already top-level columns.
- B . Selects nested fields before correctly creating the exploded column.
- C . exploded_df = sensor_df.withColumn("record_exploded", explode("record"))
exploded_df = exploded_df.select("record_datetime" , "record_exploded.sensor_id" , "record_exploded.status" , "record_exploded.health") - D . exploded_df = exploded_df.select("record_datetime", "record_exploded")