Databricks-Certified-Data-Analyst-Associate 試験問題を無料オンラインアクセス

Which of the following describes how Databricks SQL should be used in relation to other business intelligence (BI) tools like Tableau, Power BI, and looker?

• A.As a complete replacement with additional functionality
• B.As a complementary tool for quick in-platform Bl work
• C.As a substitute with less functionality
• D.As an exact substitute with the same level of functionality
• E.As a complementary tool for professional-grade presentations

A data analyst is working with gold-layer tables to complete an ad-hoc project. A stakeholder has provided the analyst with an additional dataset that can be used to augment the gold-layer tables already in use.
Which of the following terms is used to describe this data augmentation?

• A.Last-mile ETL
• B.Data enhancement
• C.Last-mile
• D.Data testing
• E.Ad-hoc improvements

A data scientist has asked a data analyst to create histograms for every continuous variable in a data set. The data analyst needs to identify which columns are continuous in the data set.
What describes a continuous variable?

• A.A quantitative variable that can take on an uncountable set of values
• B.A quantitative variable Chat can take on a finite or countably infinite set of values
• C.A quantitative variable that never stops changing
• D.A categorical variable in which the number of categories continues to increase over time

A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result:

Which query did the analyst execute in order to get this result?

• A.
• B.
• C.
• D.

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 dat
a. 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.The dashboard cannot be refreshed that quickly
• B.The streaming data is not an appropriate data source for a dashboard
• C.The streaming cluster is not fault tolerant
• D.The gold-level tables are not appropriately clean for business reporting
• E.The required compute resources could be costly