DDL

Question 1

CREATE
OPTIONS
AS SELECT

Answer 1

CREATE TABLE mydataset.top_words
OPTIONS(
description=”Top ten words per Shakespeare corpus”
) AS
SELECT
corpus,
ARRAY_AGG(STRUCT(word, word_count) ORDER BY word_count DESC LIMIT 10) AS top_words
FROM bigquery-public-data.samples.shakespeare
GROUP BY corpus;

Question 2

CREATE FUNCTION

Answer 2

CREATE [TEMP] FUNCTION mydataset.multiplyInputs(
    x FLOAT64, y FLOAT64
)
RETURNS FLOAT64
AS (x * y);

Question 3

CREATE PROCEDURE

Answer 3

CREATE PROCEDURE

Question 4

CREATE EXTERNAL TABLE

Answer 4

CREATE OR REPLACE EXTERNAL TABLE mydataset.sales
OPTIONS (
format = ‘CSV’,
uris = [‘gs://mybucket/sales.csv’]);