logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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 tool does Snowflake offer for scripting tasks?

  • Tasks
  • Pipelines
  • Jobs
  • Snowpipe
Mark for review

Snowflake separates compute and storage to allow:

  • Query optimization
  • Independent scaling
  • Easier UI
  • Increased cost
Mark for review

Snowflake organizes storage in:

  • Micro-partitions
  • Workbooks
  • Data vaults
  • Virtual blocks
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 privilege is needed to access a specific table?

  • USAGE
  • SELECT
  • EXECUTE
  • READ
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 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 default file format supported by Snowflake COPY command?

  • XML
  • JSON
  • CSV
  • Parquet
Mark for review

Which data type is used for storing text in Snowflake?

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

Which Snowflake edition supports encrypted data transfer between VPCs?

  • All editions
  • Enterprise edition and above
  • Business Critical edition and Above
  • VPS edition only
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

Can you scale Snowflake warehouses automatically?

  • Depends on edition
  • Yes, with multi-cluster warehouses
  • Only manually
  • No
Mark for review

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

  • SYSADMIN
  • ACCOUNTADMIN
  • SECURITYADMIN
  • USERADMIN
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 object type is a UDF in Snowflake?

  • User-defined field
  • User-defined function
  • Utility-driven file
  • User data factory
Mark for review

Which feature allows secure data sharing between Snowflake accounts?

  • Data Sharing
  • Data Masking
  • Data Cloning
  • Data Encryption
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 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 INFORMATION_SCHEMA provide?

  • Query syntax examples
  • Metadata and object details
  • External data source
  • Row-level security
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 encryption standard does Snowflake use for data at rest?

  • AES-128
  • AES-256
  • RSA-2048
  • RSA-4096
Mark for review

Which role is required to create new warehouses?

  • WAREHOUSEADMIN
  • READER
  • SYSADMIN
  • PUBLIC
Mark for review

What kind of object is STREAM in Snowflake?

  • Job scheduler
  • File uploader
  • Index builder
  • Change Data Capture (CDC)
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 purpose of WAREHOUSE keyword in a SQL statement?

  • Allocates storage
  • Defines login
  • Adds user
  • Specifies compute resource
Mark for review

In Snowflake, a Virtual Warehouse is used for:

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

What does GRANT USAGE ON WAREHOUSE do?

  • Assigns billing
  • Grants access to use compute
  • Gives storage access
  • Gives permission to query tables
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

What does the ROLE keyword refer to in Snowflake?

  • User's project
  • Compute level permission
  • Storage access
  • Access level container
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