# 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
        
    * <mark>Cloud Spanner</mark>
        
    * 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
        
    * <mark>Cloud Spanner</mark>
        
    * 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
        
    * <mark>bq ls</mark>
        
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
        
    * <mark>bq create</mark>
        
    * 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
        
    * <mark>SELECT DISTINCT</mark>
        
    * 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
        
    * <mark>Inner Join</mark>
        
    * Cross Join
        

---

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1740456997162/898a211a-ebc9-4dc5-ab74-ef75744f72a7.png align="center")