logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

How many clusters can a multi-cluster warehouse have?

  • Up to 10
  • Depends on configuration
  • 1
  • 4
Mark for review

Which Snowflake feature allows continuous data loading from cloud storage?

  • Task
  • Stream
  • Snowpipe
  • Stage
Mark for review

What is the default role assigned to a new user?

  • SYSADMIN
  • PUBLIC
  • ACCOUNTADMIN
  • DEVELOPER
Mark for review

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

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

Snowflake organizes storage in:

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

What does INFORMATION_SCHEMA provide in Snowflake?

  • Login logs
  • System metadata
  • Query editor
  • Job control
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 a Snowflake database store?

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

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

  • XML
  • JSON
  • CSV
  • Parquet
Mark for review

What command creates a database in Snowflake?

  • CREATE DB
  • NEW DATABASE
  • CREATE DATABASE
  • MAKE DATABASE
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 privilege is needed to access a specific table?

  • USAGE
  • SELECT
  • EXECUTE
  • READ
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 of the following is not a valid Snowflake privilege?

  • SELECT
  • INSERT
  • EXECUTE
  • DELETEALL
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

Snowpipe in Snowflake is used for:

  • Manual loading
  • Scheduled loading
  • Continuous data loading
  • External query logs
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 kind of object is STREAM in Snowflake?

  • Job scheduler
  • File uploader
  • Index builder
  • Change Data Capture (CDC)
Mark for review

Which encryption standard does Snowflake use for data at rest?

  • AES-128
  • AES-256
  • RSA-2048
  • RSA-4096
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

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 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

Snowflake shares data using:

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

Which clause is used to limit the number of rows in a SELECT query?

  • WHERE
  • LIMIT
  • ROWCOUNT
  • MAXROWS
Mark for review

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

  • STRING
  • VARIANT
  • BINARY
  • BOOLEAN
Mark for review

What object type is TASK in Snowflake?

  • Query optimizer
  • Stored procedure
  • Workflow trigger
  • Background job
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

Snowflake separates compute and storage to allow:

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

What language are Snowflake Stored Procedures written in (natively)?

  • Python
  • Java
  • SQL
  • JavaScript
Mark for review

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

  • Stored procedure
  • Custom SQL function
  • Trigger
  • Function from BI tool
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