Two of the most common data locations on Databricks are the DBFS root storage and external object storage mounted with dbutils.fs.mount().
Which of the following statements is correct?

• A. DBFS is a file system protocol that allows users to interact with files stored in object storage using syntax and guarantees similar to Unix file systems.
• B. Neither the DBFS root nor mounted storage can be accessed when using %sh in a Databricks notebook.
• C. By default, both the DBFS root and mounted data sources are only accessible to workspace administrators.
• D. The DBFS root is the most secure location to store data, because mounted storage volumes must have full public read and write permissions.
• E. The DBFS root stores files in ephemeral block volumes attached to the driver, while mounted directories will always persist saved data to external storage between sessions.

The business intelligence team has a dashboard configured to track various summary metrics for retail stories. This includes total sales for the previous day alongside totals and averages for a variety of time periods. The fields required to populate this dashboard have the following schema:

For Demand forecasting, the Lakehouse contains a validated table of all itemized sales updated incrementally in near real-time. This table named products_per_order, includes the following fields:

Because reporting on long-term sales trends is less volatile, analysts using the new dashboard only require data to be refreshed once daily. Because the dashboard will be queried interactively by many users throughout a normal business day, it should return results quickly and reduce total compute associated with each materialization.
Which solution meets the expectations of the end users while controlling and limiting possible costs?

• A. Configure a webhook to execute an incremental read against products_per_order each time the dashboard is refreshed.
• B. Use Structure Streaming to configure a live dashboard against the products_per_order table within a Databricks notebook.
• C. Populate the dashboard by configuring a nightly batch job to save the required values as a table overwritten with each update.
• D. Define a view against the products_per_order table and define the dashboard against this view.
• E. Use the Delta Cache to persists the products_per_order table in memory to quickly the dashboard with each query.

A security team wants to enforce data protection for a customer table containing customer PII data. To comply with local policies, sales team members should only see customers from their region, while non-admin users should have email addresses masked. Which implementation approach should be used when using Unity Catalog row filters and column masks?

• A. Create SQL UDFs for row filtering based on user region and column masking based on group membership, then apply them using ALTER TABLE SET ROW FILTER and ALTER COLUMN SET MASK commands.
• B. Create a view with dynamic WHERE clauses for region filtering and use string replacement functions for email masking using ALTER COLUMN SET MASK command.
• C. Use table ACLs to restrict access using tags with GRANT SELECT ON table_name WITH TAG command, and rely on application-level filtering for sensitive data based on user region.
• D. Implement row filters with SQL UDFs based on user region only since column masks cannot be combined with row filters on the same table, then apply them be recreating the table with DROP TABLE and CREATE TABLE SET ROW FILTER commands.

All records from an Apache Kafka producer are being ingested into a single Delta Lake table with the following schema:
key BINARY, value BINARY, topic STRING, partition LONG, offset LONG, timestamp LONG There are 5 unique topics being ingested. Only the "registration" topic contains Personal Identifiable Information (PII). The company wishes to restrict access to PII. The company also wishes to only retain records containing PII in this table for 14 days after initial ingestion.
However, for non-PII information, it would like to retain these records indefinitely.
Which of the following solutions meets the requirements?

• A. Because the value field is stored as binary data, this information is not considered PII and no special precautions should be taken.
• B. Data should be partitioned by the registration field, allowing ACLs and delete statements to be set for the PII directory.
• C. Separate object storage containers should be specified based on the partition field, allowing isolation at the storage level.
• D. Data should be partitioned by the topic field, allowing ACLs and delete statements to leverage partition boundaries.
• E. All data should be deleted biweekly; Delta Lake's time travel functionality should be leveraged to maintain a history of non-PII information.