Manipulate Columns, Rows, and Table Structures by Adding, Dropping, Splitting, Renaming Column Names, Applying Filters, and Exploding Arrays. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which SQL command adds a new column to an existing table?

   • ACREATE TABLE ... ADD COLUMN
   • BMODIFY TABLE ... ADD COLUMN
   • CUPDATE TABLE ... ADD COLUMN
   • DALTER TABLE ... ADD COLUMN
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which function transforms an array column into multiple rows?

   • Acollect_list
   • Bpivot
   • Cexplode
   • Dsplit
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which DataFrame transformation method adds a new column to a DataFrame?

   • AwithColumn
   • Bfilter
   • Cdrop
   • DorderBy
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which of the following adds a new column named 'status' with the constant string 'active' to a DataFrame `df`?

   • Adf.withColumn('status', 'active')
   • Bdf.select('status', 'active')
   • Cdf.addColumn('status', 'active')
   • Ddf.withColumn('status', lit('active'))
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which method combines two DataFrames with the same schema, stacking their rows?

   • Amerge
   • Bconcat
   • Cjoin
   • Dunion
   Reveal Solution Discussion Select an answer first