Which of the following statements about Legacy SQL and Standard SQL is not true?

Question

Options

• AStandard SQL is the preferred query language for BigQuery.
• BIf you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
• COne difference between the two query languages is how you specify fully-qualified table names (i.e. table names that include their associated project name).
• DYou need to set a query language for each dataset and the default is Standard SQL.

• A
  4% (1)
• C
  4% (1)
• D
  93% (26)

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. https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql

No community discussion yet for this question.