Explanation:
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.
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.
No comments yet.