logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which data type is used for storing text in Snowflake?

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

Snowpipe in Snowflake is used for:

  • Manual loading
  • Scheduled loading
  • Continuous data loading
  • External query logs
Mark for review

How do you schedule a task in Snowflake?

  • Use WHEN clause
  • Use CRON expression
  • Use SCHEDULE() method
  • Use TIME BLOCK
Mark for review

What does a Snowflake database store?

  • APIs only
  • Only reports
  • Tables, schemas, procedures
  • Code only
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

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

What does the Stream object capture?

  • Row-level changes
  • Table schema changes
  • Role changes
  • Data masking updates
Mark for review

What does GRANT OWNERSHIP do in Snowflake?

  • Grants read-only access
  • Transfers control of object
  • Assigns compute credit
  • Sets access expiration
Mark for review

Snowflake separates compute and storage to allow:

  • Query optimization
  • Independent scaling
  • Easier UI
  • Increased cost
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

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 default file format supported by Snowflake COPY command?

  • XML
  • JSON
  • CSV
  • Parquet
Mark for review

What does the Query Profile help you understand in Snowflake?

  • Query performance
  • Account usage
  • Storage usage
  • Session logs
Mark for review

Time Travel in Snowflake allows:

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

Which of the following can be used to connect to Snowflake?

  • SnowSQL
  • Web UI
  • JDBC/ODBC
  • All of the above
Mark for review

What is the Snowflake Result Cache?

  • A cache for storing query results
  • A cache for storing data
  • A cache for storing metadata
  • A cache for storing backup data
Mark for review

What kind of object is STREAM in Snowflake?

  • Job scheduler
  • File uploader
  • Index builder
  • Change Data Capture (CDC)
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 Warehouse in Snowflake used for?

  • Temporary staging
  • Data backup
  • Metadata storage
  • Query processing
Mark for review

What object type is a UDF in Snowflake?

  • User-defined field
  • User-defined function
  • Utility-driven file
  • User data factory
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

Which of the following cloud platforms does Snowflake support?

  • Azure
  • Google Cloud
  • AWS
  • All of the above
Mark for review

Zero-Copy Cloning in Snowflake allows:

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

Which of the following is not a valid Snowflake privilege?

  • SELECT
  • INSERT
  • EXECUTE
  • DELETEALL
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 language are Snowflake Stored Procedures written in (natively)?

  • Python
  • Java
  • SQL
  • JavaScript
Mark for review

What does a stream not capture?

  • Inserted rows
  • Updated rows
  • Deleted rows
  • Schema changes
Mark for review

Snowflake organizes storage in:

  • Micro-partitions
  • Workbooks
  • Data vaults
  • Virtual blocks
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 INFORMATION_SCHEMA provide in Snowflake?

  • Login logs
  • System metadata
  • Query editor
  • Job control
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