Data Engineering - GET Training Assessment - Part 2

An engaging digital illustration depicting data engineering concepts, featuring elements like cloud storage, databases, and analytics visualizations, in a modern and professional style.

Data Engineering Assessment Quiz

Test your knowledge in data engineering with our comprehensive assessment quiz. This quiz consists of 10 multiple-choice and checkbox questions focused on Google BigQuery and data handling techniques. Perfect for professionals looking to enhance their skills or prepare for certifications.

Multiple-choice questions
Instant feedback on answers
Access to a certificate upon completion

10 Questions2 MinutesCreated by RunningData101

Your company is using WILDCARD tables to query data across multiple tables with similar names.
The SQL statement is currently failing with the following error: # Syntax error : Expected end of statement but got "-" at [4:11]

SELECT age -
FROM -
bigquery-public-data.noaa_gsod.gsod
WHERE - age != 99 AND_TABLE_SUFFIX = "˜1929'
ORDER BY - age DESC

Which table name will make the SQL statement work correctly?

"˜bigquery-public-data.noaa_gsod.gsod"˜

Bigquery-public-data.noaa_gsod.gsod*

"˜bigquery-public-data.noaa_gsod.gsod'*

`˜bigquery-public-data.noaa_gsod.gsod*`

You are building new real-time data warehouse for your company and will use Google BigQuery streaming inserts. There is no guarantee that data will only be sent in once but you do have a unique ID for each row of data and an event timestamp. You want to ensure that duplicates are not included while interactively querying data. Which query type should you use?

Include ORDER BY DESK on timestamp column and LIMIT to 1.

Use GROUP BY on the unique ID column and timestamp column and SUM on the values.

Use the LAG window function with PARTITION by unique ID along with WHERE LAG IS NOT NULL.

Use the ROW_NUMBER window function with PARTITION by unique ID along with WHERE row equals 1.

All query results, including both interactive and batch queries, are cached in temporary tables for approximately

24 hours

12 hours

7 days

48 hours

In Bigquery. Which clusters run on dozens of thousands of machines and hundreds of thousands of cores, so your query which used 3300 CPUs only used a fraction of the capacity reserved for BigQuery?

Borg

Colossus

Jupiter

Mixers

Which of the following aggregate function returns the total number of values? Choose the correct option from below list

MAX()

FIRST()

AVG()

COUNT()

The data to be loaded into the BigQuery from the cloud storage can be of ______ format. Choose the correct option from below list.(Select one or more options)

Data Engineering - GET Training Assessment - Part 2

Data Engineering Assessment Quiz

More Quizzes