Exam Databricks-Certified-Professional-Data-Engineer Topic 1 Question 54 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam
Question #: 54
Topic #: 1

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?

A. CREATE TABLE AS SELECT statements infer the schema by scanning the data B. CREATE TABLE AS SELECT statements adopt schema details from the source table and query C. CREATE TABLE AS SELECT statements result in tables that do not support schemas D. CREATE TABLE AS SELECT statements result in tables where schemas are optional E. CREATE TABLE AS SELECT statements assign all columns the type STRING

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business