logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

What does a Snowflake database store?

  • APIs only
  • Only reports
  • Tables, schemas, procedures
  • Code only
Mark for review

Time Travel in Snowflake allows:

  • Recovering dropped data
  • Audit logs only
  • Real-time alerts
  • Tracking query history
Mark for review

Zero-Copy Cloning in Snowflake allows:

  • Creating fast, space-efficient copies
  • Index rebuilding
  • Creating backups
  • File duplication
Mark for review

What does the ROLE keyword refer to in Snowflake?

  • User's project
  • Compute level permission
  • Storage access
  • Access level container
Mark for review

What is the default file format supported by Snowflake COPY command?

  • XML
  • JSON
  • CSV
  • Parquet
Mark for review

Which Snowflake feature allows continuous data loading from cloud storage?

  • Task
  • Stream
  • Snowpipe
  • Stage
Mark for review

What command creates a database in Snowflake?

  • CREATE DB
  • NEW DATABASE
  • CREATE DATABASE
  • MAKE DATABASE
Mark for review

Which Snowflake command lists all existing databases?

  • LIST DATABASES
  • SHOW DATABASES
  • GET DATABASES
  • PRINT DATABASES
Mark for review

What is a secure view in Snowflake?

  • View protected by password
  • View with enforced row-level security
  • View with time travel
  • View that can?t be shared
Mark for review

What is the User object in Snowflake for?

  • Manage user accounts
  • Manage permissions
  • Create warehouses
  • Configure encryption
Mark for review

What does the clustering key help optimize?

  • Metadata access
  • Query performance
  • Data masking
  • Backup retention
Mark for review

What is used to manage user permissions in Snowflake?

  • ABAC (Attribute-Based)
  • OAuth
  • IAM
  • RBAC (Role-Based Access Control)
Mark for review

Which SQL command is used to remove a database in Snowflake?

  • REMOVE DATABASE
  • DROP DATABASE
  • DELETE DATABASE
  • UNSET DATABASE
Mark for review

What command is used to unload data from Snowflake to external location?

  • COPY INTO FROM
  • UNLOAD TO
  • EXPORT DATA
  • DUMP TO FILE
Mark for review

What is the Fail-safe feature in Snowflake?

  • Allows users to restore data to a previous state
  • Prevents data loss from hardware failure
  • Travel to previous data version
  • Stores encrypted backups
Mark for review

Which feature allows secure data sharing between Snowflake accounts?

  • Data Sharing
  • Data Masking
  • Data Cloning
  • Data Encryption
Mark for review

What is a Snowflake user-defined function (UDF)?

  • Stored procedure
  • Custom SQL function
  • Trigger
  • Function from BI tool
Mark for review

What does ?undrop? do in Snowflake?

  • Recovers dropped object
  • Deletes latest backup
  • Removes permissions
  • Refreshes schema
Mark for review

In Snowflake, which statement is used to remove a table?

  • REMOVE TABLE
  • DESTROY TABLE
  • DROP TABLE
  • DELETE TABLE
Mark for review

Which of these roles is the default role for a new Snowflake user?

  • SYSADMIN
  • SECURITYADMIN
  • USERADMIN
  • PUBLIC
Mark for review

What is the purpose of the Snowflake Metadata Store?

  • Stores user data
  • Stores metadata about Snowflake objects
  • Stores backup copies of Snowflake databases
  • Stores the results of Snowflake queries
Mark for review

What is the primary purpose of Snowflake's Virtual Warehouse?

  • Data storage
  • Query processing
  • Data replication
  • Data backup
Mark for review

What is the default auto-suspend time for a new warehouse?

  • 5 minutes
  • 10 minutes
  • 0 seconds
  • 600 seconds
Mark for review

Which is a valid data type for storing binary data in Snowflake?

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

How is fail-safe different from time travel in Snowflake?

  • It's for billing audit only
  • Retains data after time travel expires
  • It creates backups
  • It's not different
Mark for review

What is the Stream feature used for in Snowflake?

  • Real-time data capture
  • External ETL
  • Snowpipe enhancement
  • Query acceleration
Mark for review

Snowflake is primarily a ____.

  • Cloud Data Warehouse
  • ETL Tool
  • Database IDE
  • BI Tool
Mark for review

How can you grant access to a table in Snowflake?

  • Use GRANT USAGE
  • Use GRANT SELECT
  • Use ASSIGN ROLE
  • Use CONNECT PRIVILEGE
Mark for review

What type of architecture does Snowflake use?

  • Multi-cluster shared disk
  • Multi-cluster shared data
  • Monolithic
  • Client-server
Mark for review

What is the Snowflake Data Marketplace?

  • Buy/sell data sets
  • Share internal datasets
  • Access public datasets
  • Create virtual links to other accounts
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session