Claim Your Black Friday Savings: 75% Off! Apply coupon code below to get your exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: ac75sure

A data analyst is working with a nested array column products in table transactions.

A data analyst is working with a nested array column products in table transactions. The analyst wants to return the first item in the array for each row.

The data analyst is using the following incomplete command:

SELECT

transaction_id,

_____ AS first_product

FROM transactions;

Which line of code should the data analyst use to fill in the blank so that it successfully completes the task?

A.

products.1

B.

products.0

C.

products[0]

D.

products[1]

Databricks-Certified-Data-Analyst-Associate PDF/Engine
  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions
buy now Databricks-Certified-Data-Analyst-Associate pdf
Get 75% Discount on All Products, Use Coupon: "ac75sure"