Answer-first summary for fast verification
Answer: The query language is set for each dataset, with Standard SQL as the default.
The correct answer is D because the query language is not set for each dataset; it is specified each time a query is run, with Legacy SQL being the default. Standard SQL became the preferred language with the release of BigQuery 2.0. Differences in syntax, such as the use of a colon (:) in Legacy SQL versus a period (.) in Standard SQL for project-qualified table names, can cause errors when switching between the two. For more details, refer to [Google's documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which statement regarding Legacy SQL and Standard SQL in BigQuery is incorrect?
A
Standard SQL is the preferred query language for BigQuery.
B
Legacy SQL queries may produce errors when run with Standard SQL due to syntax differences.
C
The method of specifying fully-qualified table names differs between Legacy SQL and Standard SQL.
D
The query language is set for each dataset, with Standard SQL as the default.