logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Zero-Copy Cloning in Snowflake allows:

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

What is the Warehouse in Snowflake used for?

  • Temporary staging
  • Data backup
  • Metadata storage
  • Query processing
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 does the clustering key help optimize?

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

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

  • INTEGER
  • TIMESTAMP
  • FLOAT
  • TEXT
Mark for review

Snowflake is primarily a ____.

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

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

  • XML
  • JSON
  • CSV
  • Parquet
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

In Snowflake, a Virtual Warehouse is used for:

  • Data replication
  • Query processing
  • Metadata management
  • Data storage
Mark for review

What does INFORMATION_SCHEMA provide in Snowflake?

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

What does the Query Profile help you understand in Snowflake?

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

Which language is used to interact with Snowflake?

  • Python
  • JavaScript
  • SQL
  • Scala
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

Which of the following is a key feature of Snowflake?

  • Virtual Warehouses
  • Real-time dashboards
  • Cloud ML Pipelines
  • Key-value storage
Mark for review

Snowflake separates compute and storage to allow:

  • Query optimization
  • Independent scaling
  • Easier UI
  • Increased cost
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 Snowflake feature is used to load data automatically when files are added to a stage?

  • Streams
  • Materialized Views
  • Snowpipe
  • Clustering Keys
Mark for review

What is the maximum retention period for Time Travel in Enterprise Edition?

  • 90 days
  • 30 days
  • 24 hours
  • 7 days
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

Which data type is used for storing text in Snowflake?

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

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

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

Which Snowflake feature allows continuous data loading from cloud storage?

  • Task
  • Stream
  • Snowpipe
  • Stage
Mark for review

Which of the following is a valid role in Snowflake?

  • SYSADMIN
  • PUBLIC
  • ACCOUNTADMIN
  • All of the above
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 does the INFORMATION_SCHEMA provide?

  • Query syntax examples
  • Metadata and object details
  • External data source
  • Row-level security
Mark for review

Which privilege is needed to access a specific table?

  • USAGE
  • SELECT
  • EXECUTE
  • READ
Mark for review

What does the SHOW TABLES command do in Snowflake?

  • Lists all tables in current schema
  • Grants access
  • Deletes tables
  • Views table data
Mark for review

What is the Data Masking feature used for?

  • Obfuscate sensitive data
  • Encrypt data in transit
  • Share encrypted data
  • Store backups securely
Mark for review

What does the Stream object capture?

  • Row-level changes
  • Table schema changes
  • Role changes
  • Data masking updates
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