- All Exams Instant Download
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?
Which of the following is an advantage of using a Delta Lake-based data lakehouse over common data lake solutions?A . ACID transactionsB . Flexible schemasC . Data deletionD . Scalable storageE . Open-source formatsView AnswerAnswer: A Explanation: A Delta Lake-based data lakehouse is a data platform architecture that combines the...
Which of the following approaches can be used to ingest data directly from cloud-based object storage?
Which of the following approaches can be used to ingest data directly from cloud-based object storage?A . Create an external table while specifying the DBFS storage path to FROMB . Create an external table while specifying the DBFS storage path to PATHC . It is not possible to directly ingest...
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?
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 an exact substitute with the same level of functionalityB . As a substitute with less functionalityC . As a complete replacement with additional...
Which of the following describes why the data files still exist and the metadata files were deleted?
A data analyst is attempting to drop a table my_table. The analyst wants to delete all table metadata and data. They run the following command: DROP TABLE IF EXISTS my_table; While the object no longer appears when they run SHOW TABLES, the data files still exist. Which of the following...
Which of the following layers of the medallion architecture is most commonly used by data analysts?
Which of the following layers of the medallion architecture is most commonly used by data analysts?A . None of these layers are used by data analystsB . GoldC . All of these layers are used equally by data analystsD . SilverE . BronzeView AnswerAnswer: B Explanation: The gold layer of...
Which of the following approaches can be used to connect Databricks to Fivetran for data ingestion?
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 withB . Use Delta Live Tables to establish a cluster for Fivetran to interact withC ....
complete this task?
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...
Which of the following is stored alongside data files when using Delta Lake?
Delta Lake stores table data as a series of data files, but it also stores a lot of other information. Which of the following is stored alongside data files when using Delta Lake?A . None of theseB . Table metadata, data summary visualizations, and owner account informationC . Table metadataD...
Which of the following should data analysts consider when working with personally identifiable information (PII) data?
Which of the following should data analysts consider when working with personally identifiable information (PII) data?A . Organization-specific best practices for Pll dataB . Legal requirements for the area in which the data was collectedC . None of these considerationsD . Legal requirements for the area in which the analysis...
Which of the following Databricks Lakehouse Platform services/capabilities meets all of these requirements?
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...
