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.
Ultimate access to all questions.
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.