A table customerLocations exists with the following schema: 1. id STRING, 2. date STRING, 3. city STRING, 4. country STRING A senior data engineer wants to create a new table from this table using the following command: 1. CREATE TABLE customersPerCountry AS 2. SELECT country, 3. COUNT(*) AS customers 4. FROM customerLocations 5. GROUP BY country; A junior data engineer asks why the schema is not being declared for the new table. Which of the following responses explains why declaring the schema is not necessary?
Select one answer.
Purchase Full Access to view answer options & explanation
The first 119 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 395 questions.
