Describe In-Database Analytics and SQL Essentials DATA-SCIENCE-FOUNDATIONS Practice Questions (Page 1)

Questions 1–5

1. 1foundation · easy

   Which SQL function is a window function that assigns a sequential rank to each row within a partition?

   • AAVG()
   • BSUM()
   • CROW_NUMBER()
   • DCOUNT()
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which SQL clause is used to filter rows based on a condition before aggregation?

   • AHAVING
   • BGROUP BY
   • CORDER BY
   • DWHERE
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data analyst is cleaning a table `customer_data` that has a `phone` column with inconsistent formats, such as '(555) 123-4567' and '555-123-4567'. They want to standardize all phone numbers to the format '5551234567' (digits only). Which SQL approach should they use?

   • AUse REPLACE to remove parentheses and hyphens.
   • BUse REGEXP_REPLACE to remove all non-digit characters.
   • CUse CAST to convert the phone number to an integer.
   • DUse SUBSTRING to extract the digits.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which SQL function is commonly used to replace NULL values with a specified default in a query?

   • ACOALESCE
   • BCAST
   • CCONCAT
   • DTRIM
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   What is the primary characteristic of in-database analytics?

   • AStoring analytical results in a separate data warehouse for later reporting
   • BMoving data from the database to an external analytics server for processing
   • CPerforming analytical computations directly within the database engine where the data resides
   • DUsing a separate analytics appliance that replicates the database for processing
   Reveal Solution Discussion Select an answer first