- All Exams Instant Download
Which of the following statements about Legacy SQL and Standard SQL is not true?
Which of the following statements about Legacy SQL and Standard SQL is not true?
A . Standard SQL is the preferred query language for BigQuery.
B . If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQ
D . One difference between the two query languages is how you specify fully-qualified table names
(i.e. table names that include their associated project name).
E . You need to set a query language for each dataset and the default is Standard SQ
Answer: D
Explanation:
You do not set a query language for each dataset. It is set each time you run a query and the
default query language is Legacy SQL. Standard SQL has been the preferred query language since BigQuery 2.0 was released. In legacy SQL, to query a table with a project-qualified name, you use a colon, :, as a separator. In standard SQL, you use a period, ., instead. Due to the differences in syntax between the two query languages (such as with project-qualified table names), if you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
Reference:
https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments