Skills Boost Arcade Trivia February 2025 Week 4 (Solution)

Skills Boost Arcade Trivia February 2025 Week 4 (Solution)

Overview

Welcome to Skills Boost Arcade Trivia February 2025! Give your career a boost with hands-on experience with different Google Cloud and partner services.

Click Start Lab to begin.

P.S. You don't need the GCP Console for this, but you do need to keep this quiz open for a minimum of 3 minutes.

Quiz

  1. Which Google Cloud service is ideal for managing relational, structured, and semi-structured data that requires high availability, strong consistency, and supports transactional reads and writes?

    Select ONE answer that would be relevant

    • Cloud SQL

    • BigQuery

    • Cloud Spanner

    • Cloud Storage

  2. Which fully managed database service does Google Cloud offer that integrates relational, graph, key-value, and search capabilities making it suitable for mission-critical applications?

    Select ONE answer that would be relevant

    • Cloud Monitoring

    • Cloud Spanner

    • Cloud Storage

    • Compute Engine

  3. Which command will you run to list any existing datasets in your project?

    Select ONE answer that would be relevant

    • show

    • list all

    • get list

    • bq ls

  4. Which command will you run to create a new dataset in your project?

    Select ONE answer that would be relevant

    • datasets create

    • bq mk

    • bq create

    • bq datasets

  5. In SQL, which statement discards duplicate rows and returns only the remaining rows?

    Select ONE answer that would be relevant

    • SELECT ALL

    • SELECT DISTINCT

    • SELECT *

    • SELECT EXCEPT

  6. In SQL, which join matches rows between two tables and returns only the matching rows from the following?

    Select ONE answer that would be relevant

    • Full Outer Join

    • Outer Join

    • Inner Join

    • Cross Join