Quiz: Snowflake's Cloud Data Warehouse Questions!

242 Questions | Total Attempts: 1522

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

.


Questions and Answers
  • 1. 
    True or False: Data Storage is independent from compute?
    • A. 

      True

    • B. 

      False

  • 2. 
    True or False: All virtual warehouses have access to all data?
    • A. 

      True

    • B. 

      False

  • 3. 
    True or False: All interactions with data are initialized through the services layer?
    • A. 

      True

    • B. 

      False

  • 4. 
    True or False: Multi-Cluster Warehouses support high concurrency?
    • A. 

      True

    • B. 

      False

  • 5. 
    True or False: Warehouses can be dynamically expanded to adjust to workloads?
    • A. 

      True

    • B. 

      False

  • 6. 
    Which layer provides centralized services for the data warehouse?
    • A. 

      Cloud Services

    • B. 

      Query Processing

    • C. 

      Database Storage

  • 7. 
    Which layer contains virtual warehouses for data access?
    • A. 

      Cloud Services

    • B. 

      Query Processing

    • C. 

      Database Storage

  • 8. 
    Which layer contains the data in compressed, columnar format?
    • A. 

      Database Storage

    • B. 

      Cloud Services

    • C. 

      Query Processing

  • 9. 
    Snowflake's security and authentication includes Multi-Factor authentication?
    • A. 

      True

    • B. 

      False

  • 10. 
    Snowflake's security and authentication includes Snowflake Failures alerts?
    • A. 

      True

    • B. 

      False

  • 11. 
    Snowflake's security and authentication includes data encryption using Snowflake-managed keys?
    • A. 

      True

    • B. 

      False

  • 12. 
    Snowflake's security and authentication includes object-level access?
    • A. 

      True

    • B. 

      False

  • 13. 
    Snowflake's architecture includes advance capabilities in the cloud services layer that delivers transaction management for consistent operations on the same data at the same time?
    • A. 

      True

    • B. 

      False

  • 14. 
    Snowflake's architecture includes advance capabilities in the cloud services layer that delivers metadata service?
    • A. 

      True

    • B. 

      False

  • 15. 
    Snowflake's architecture includes advance capabilities in the cloud services layer that delivers security and authentication control?
    • A. 

      True

    • B. 

      False

  • 16. 
    Snowflake's architecture includes advance capabilities in the cloud services layer that delivers query optimization?
    • A. 

      True

    • B. 

      False

  • 17. 
    Snowflake supports landing data into internal stage on the cloud storage platform?
    • A. 

      True

    • B. 

      False

  • 18. 
    Snowflake supports landing data into external stage on the cloud storage platform?
    • A. 

      True

    • B. 

      False

  • 19. 
    Snowflake supports landing data into bring your own device?
    • A. 

      True

    • B. 

      False

  • 20. 
    Compute resources used by Snowflake for data loading jobs can by provide by user managed virtual warehouse?
    • A. 

      True

    • B. 

      False

  • 21. 
    Compute resources used by Snowflake for data loading jobs can by provide by Snowflake managed service?
    • A. 

      True

    • B. 

      False

  • 22. 
    Compute resources used by Snowflake for data loading jobs can by provide by hardware provisioned by user directly from cloud providers?
    • A. 

      True

    • B. 

      False

  • 23. 
    Stages are unique database objects in Snowflake?
    • A. 

      True

    • B. 

      False

  • 24. 
    Pipe are unique database objects in Snowflake?
    • A. 

      True

    • B. 

      False

  • 25. 
    Table are unique database objects in Snowflake?
    • A. 

      True

    • B. 

      False

Related Topics