Predictive Optimization is an automated Databricks service enabled by default for Unity Catalog Managed tables. It helps maintain Delta tables by continuously optimizing them to ensure optimal performance and costs. Which two operations does Predictive Optimization run to maintain the Delta tables? (Choose two.)

• A. COMPACT
• B. PARTITION BY
• C. BUCKETING
• D. OPTIMIZE
• E. ANALYZE

Explanation: Only visible for iPassleader members. You can sign-up / login (it's free).

A data engineer is analyzing transactional data in a PySpark DataFrame df containing customer_id, transaction_timestamp (precise to milliseconds), and amount_spent. The objective is to compute a cumulative sum of amount_spent per customer, strictly ordered by transaction_timestamp. The cumulative sum must include all transactions from the earliest timestamp up to and including the current row, respecting temporal ordering within each customer partition. Which PySpark code snippet most accurately constructs the appropriate window specification and applies the aggregation to yield the correct cumulative expenditure per customer?

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

Explanation: Only visible for iPassleader members. You can sign-up / login (it's free).

A small company based in the United States has recently contracted a consulting firm in India to implement several new data engineering pipelines to power artificial intelligence applications. All the company's data is stored in regional cloud storage in the United States.
The workspace administrator at the company is uncertain about where the Databricks workspace used by the contractors should be deployed.
Assuming that all data governance considerations are accounted for, which statement accurately informs this decision?

• A. Databricks notebooks send all executable code from the user's browser to virtual machines over the open internet; whenever possible, choosing a workspace region near the end users is the most secure.
• B. Cross-region reads and writes can incur significant costs and latency; whenever possible, compute should be deployed in the same region the data is stored.
• C. Databricks workspaces do not rely on any regional infrastructure; as such, the decision should be made based upon what is most convenient for the workspace administrator.
• D. Databricks runs HDFS on cloud volume storage; as such, cloud virtual machines must be deployed in the region where the data is stored.
• E. Databricks leverages user workstations as the driver during interactive development; as such, users should always use a workspace deployed in a region they are physically near.

Explanation: Only visible for iPassleader members. You can sign-up / login (it's free).

A table is registered with the following code:

Both users and orders are Delta Lake tables. Which statement describes the results of querying recent_orders?

• A. All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried.
• B. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query finishes.
• C. The versions of each source table will be stored in the table transaction log; query results will be saved to DBFS with each query.
• D. Results will be computed and cached when the table is defined; these cached results will incrementally update as new records are inserted into source tables.
• E. All logic will execute at query time and return the result of joining the valid versions of the source tables at the time the query began.

Explanation: Only visible for iPassleader members. You can sign-up / login (it's free).

A data company uses Databricks Unity Catalog and has multiple enterprise data sources, including PostgreSQL, Snowflake, and SQL Server. The central data platform team wants to configure Lakehouse Federation so analysts can query external tables directly in Databricks using Databricks SQL, without duplicating data. Which steps are necessary to configure Lakehouse Federation in a secure and governed manner?

• A. Configure connections and foreign catalog in Unity Catalog, then grant access to foreign catalogs, schemas, and tables using Unity Catalog permissions.
• B. Create external locations and storage credentials to connect to each database, then register foreign tables in Unity Catalog.
• C. Mirror the external datasets into Delta Lake using Auto Loader, and govern them using Data Lineage and System Tables.
• D. Use Partner Connect to create linked datasets, and apply table ACLs at the source system to govern access through Databricks.

Explanation: Only visible for iPassleader members. You can sign-up / login (it's free).