Azure Databricks Kantar Day 7

Which among the following is a predictive optimization operation to reduce storage costs by deleting data files no longer referenced by the table

• CHECKSUM

• VACUUM

• OPTIMIZE

Which among the following was previously called Delta caching?

• Disk Caching

• Manual Caching

• Automatic Caching

______________ introduces a collection of capabilities that enable you to use cloud-based lifecycle policies on cloud object storage containing Delta tables.

• Adaptive query

• Cost based optimizer

• Archival support

Spark SQL can use a __________ to improve query plans.

• Cost-based optimizer (CBO)

• Archival support

• Adaptive query

A __________________takes an array, implements how the array is processed, and what the result of the computation will be.

• higher-order function

• lambda function

• delta parameter

A _____________is a join in which the condition contains predicates specifying that a value from one relation is between two values from the other relation.

• point in time join

• point in interval range join

• point in interval outer join

A ________________ is a join in which the condition contains predicates specifying an overlap of intervals between two values from each relation.

• point in interval range join

• interval overlap outer join

• interval overlap range join

To enable the range join optimization in a SQL query, you can use a __________to specify the bin size.

• range join hint

• left join hint

• inner join hint

_________ improves query performance by skipping directories that do not contain data files that match query predicates.

• Disk caching

• Low shuffle merge

• Dynamic file pruning

Disk caching reduces the number of data files rewritten by MERGE operations and reduces the need to recalculate ZORDER clusters. True or False?

• True

• False