Perform Data Cleaning on Unity Catalog Tables in SQL, Including Removing Invalid Data or Handling Missing Values. DATA-ANALYST-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which SQL statement removes rows with invalid data from a Unity Catalog table named `sales_raw`?

   • AUPDATE sales_raw SET quantity = NULL WHERE quantity < 0;
   • BTRUNCATE TABLE sales_raw;
   • CDELETE FROM sales_raw WHERE quantity < 0;
   • DDROP TABLE sales_raw;
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which SQL statement is valid for cleaning data in a Unity Catalog table named `customers`?

   • ADELETE customers WHERE email IS NULL;
   • BDELETE FROM customers WHERE email IS NULL;
   • CREMOVE FROM customers WHERE email IS NULL;
   • DDROP ROW FROM customers WHERE email IS NULL;
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which SQL function converts a string column to all uppercase letters?

   • ACAST
   • BTRIM
   • CLOWER
   • DUPPER
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which SQL function removes leading and trailing spaces from a string column?

   • AUPPER
   • BLOWER
   • CTRIM
   • DCAST
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   How can a data analyst perform data cleaning on a table registered in Unity Catalog?

   • AUsing standard SQL statements like UPDATE and DELETE on the table
   • BOnly by using Python notebooks
   • COnly by using the Unity Catalog UI
   • DOnly by exporting the table to a local file first
   Reveal Solution Discussion Select an answer first