logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which Snowflake feature allows continuous data loading from cloud storage?

  • Task
  • Stream
  • Snowpipe
  • Stage
Mark for review

What is a fail-safe in Snowflake?

  • Network security layer
  • Automatic backup
  • Data recovery after Time Travel
  • Query logging
Mark for review

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

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

What does INFORMATION_SCHEMA provide in Snowflake?

  • Login logs
  • System metadata
  • Query editor
  • Job control
Mark for review

Time Travel in Snowflake allows:

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

What does the Query Profile help you understand in Snowflake?

  • Query performance
  • Account usage
  • Storage usage
  • Session logs
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

Zero-Copy Cloning in Snowflake allows:

  • Creating fast, space-efficient copies
  • Index rebuilding
  • Creating backups
  • File duplication
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 a sequence in Snowflake?

  • A group of related warehouses
  • A database clone
  • An auto-incrementing numeric generator
  • A security feature
Mark for review

Which of these best describes a Snowflake stage?

  • Temporary login
  • Storage location for files
  • Backup point
  • External server
Mark for review

Snowflake organizes storage in:

  • Micro-partitions
  • Workbooks
  • Data vaults
  • Virtual blocks
Mark for review

What is the result of suspending a Snowflake warehouse?

  • All data is lost
  • Compute is paused
  • Users are logged out
  • Roles are removed
Mark for review

Snowflake shares data using:

  • Secure Data Sharing
  • Data bundles
  • REST API only
  • FTP
Mark for review

What is the default role in Snowflake that has all privileges?

  • SYSADMIN
  • ACCOUNTADMIN
  • SECURITYADMIN
  • USERADMIN
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

Which privilege is needed to access a specific table?

  • USAGE
  • SELECT
  • EXECUTE
  • READ
Mark for review

What is the maximum number of nodes that can be configured in a Snowflake cluster?

  • 50
  • 100
  • 200
  • 500
Mark for review

What does the AUTO_RESUME setting do for a warehouse?

  • Starts it when needed
  • Pauses it automatically
  • Sends notification
  • Increases performance
Mark for review

Which Snowflake command lists all existing databases?

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

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

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

What is the purpose of the Task feature in Snowflake?

  • Automate SQL execution
  • Create stored procedures
  • Write UDFs
  • Manage warehouses
Mark for review

What does the keyword AUTO_SUSPEND mean in Snowflake?

  • Suspends unused sessions
  • Suspends the warehouse after inactivity
  • Suspends query execution
  • Suspends billing only
Mark for review

What does ?undrop? do in Snowflake?

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

What happens if you drop a table in Snowflake with Time Travel enabled?

  • It's permanently deleted
  • It?s recoverable within retention period
  • It's immediately encrypted
  • It?s shared with admin
Mark for review

What is the file size limit Snowflake recommends for best performance during load?

  • 1 GB
  • 100?250 MB
  • No limit
  • < 10 MB
Mark for review

Which of the following is a valid role in Snowflake?

  • SYSADMIN
  • PUBLIC
  • ACCOUNTADMIN
  • All of the above
Mark for review

Which of the following is a valid Snowflake data type for storing dates and times?

  • INTEGER
  • TIMESTAMP
  • FLOAT
  • TEXT
Mark for review

What does the COPY INTO command do?

  • Inserts data into a table
  • Loads data from files into Snowflake
  • Merges streams
  • Generates UDFs
Mark for review

What does the clustering key help optimize?

  • Metadata access
  • Query performance
  • Data masking
  • Backup retention
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