Databricks Certified Data Analyst Associate Exam Practice Questions (P. 2)
- Full Access (45 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
A data analyst has set up a SQL query to run every four hours on a SQL endpoint, but the SQL endpoint is taking too long to start up with each run.
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
Which of the following changes can the data analyst make to reduce the start-up time for the endpoint while managing costs?
- AReduce the SQL endpoint cluster size
- BIncrease the SQL endpoint cluster size
- CTurn off the Auto stop feature
- DIncrease the minimum scaling value
- EUse a Serverless SQL endpoint
Correct Answer:
E
E
send
light_mode
delete
Question #7
A data engineering team has created a Structured Streaming pipeline that processes data in micro-batches and populates gold-level tables. The microbatches are triggered every minute.
A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.
Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?
A data analyst has created a dashboard based on this gold-level data. The project stakeholders want to see the results in the dashboard updated within one minute or less of new data becoming available within the gold-level tables.
Which of the following cautions should the data analyst share prior to setting up the dashboard to complete this task?
- AThe required compute resources could be costly
- BThe gold-level tables are not appropriately clean for business reporting
- CThe streaming data is not an appropriate data source for a dashboard
- DThe streaming cluster is not fault tolerant
- EThe dashboard cannot be refreshed that quickly
Correct Answer:
A
A
send
light_mode
delete
Question #8
Which of the following approaches can be used to ingest data directly from cloud-based object storage?
- ACreate an external table while specifying the DBFS storage path to FROM
- BCreate an external table while specifying the DBFS storage path to PATH
- CIt is not possible to directly ingest data from cloud-based object storage
- DCreate an external table while specifying the object storage path to FROM
- ECreate an external table while specifying the object storage path to LOCATION
Correct Answer:
E
E
send
light_mode
delete
Question #9
A data analyst wants to create a dashboard with three main sections: Development, Testing, and Production. They want all three sections on the same dashboard, but they want to clearly designate the sections using text on the dashboard.
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?
Which of the following tools can the data analyst use to designate the Development, Testing, and Production sections using text?
- ASeparate endpoints for each section
- BSeparate queries for each section
- CMarkdown-based text boxesMost Voted
- DDirect text written into the dashboard in editing mode
- ESeparate color palettes for each section
Correct Answer:
C
C
send
light_mode
delete
Question #10
A data analyst needs to use the Databricks Lakehouse Platform to quickly create SQL queries and data visualizations. It is a requirement that the compute resources in the platform can be made serverless, and it is expected that data visualizations can be placed within a dashboard.
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?
- ADelta Lake
- BDatabricks Notebooks
- CTableau
- DDatabricks Machine Learning
- EDatabricks SQLMost Voted
Correct Answer:
E
E
send
light_mode
delete
All Pages