Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

Explanation:

The INTEGER data type is the most suitable for associating a numerical value with each key in a SQL table. Here's why:

INTEGER is designed to store whole numbers efficiently, making it ideal for numerical values that don't require decimal points.
STRUCT is a complex type meant for collections of named fields, not for simple key-value numerical associations.
ARRAY stores ordered collections of elements, not suited for associating a single numerical value with a key.
MAP can store key-value pairs but introduces unnecessary complexity for this straightforward need.

Thus, INTEGER stands out as the optimal choice for this scenario.

Explanation:

The INTEGER data type is the most suitable for associating a numerical value with each key in a SQL table. Here's why:

INTEGER is designed to store whole numbers efficiently, making it ideal for numerical values that don't require decimal points.
STRUCT is a complex type meant for collections of named fields, not for simple key-value numerical associations.
ARRAY stores ordered collections of elements, not suited for associating a single numerical value with a key.
MAP can store key-value pairs but introduces unnecessary complexity for this straightforward need.

Thus, INTEGER stands out as the optimal choice for this scenario.

Comments (0)

No comments yet.

Real Exam

STRUCT

13.8%

INTEGER

50.9%

ARRAY

12.1%

MAP

23.2%