Snowflake Database Knowledge Exam
37 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which Snowflake edition is certified for use with data subject to regulations like HIPAA and PCI?

  • Enterprise Edition
  • Standard Edition
  • Business Critical Edition (correct)
  • Community Edition

    • What are two benefits of Snowflake using cloud provider object storage for persistent data?

  • High availability and durability (correct)
  • Inexpensive storage (correct)
  • Customer-configurable encryption algorithms
  • Leverage cloud provider GUI storage tools

    • Which two of the following are system defined roles?

  • ACCOUNTADMIN (correct)
  • SYSADMIN (correct)
  • ROLEADMIN
  • WAREHOUSEADMIN

    • What is the default maximum number of clusters in a multi-cluster Warehouse?

    <p>10</p> Signup and view all the answers

    Which Snowflake data type is designed for semi-structured data storage?

    <p>VARIANT</p> Signup and view all the answers

    What is the main feature of a virtual warehouse in Snowflake?

    <p>A compute cluster that processes queries</p> Signup and view all the answers

    Which method does Snowflake use for data encryption?

    <p>It uses SSL/TLS for data in transit and AES for data at rest</p> Signup and view all the answers

    What is the objective of Snowflake's data sharing capability?

    <p>To share data across various Snowflake accounts</p> Signup and view all the answers

    Which of the following is not a component of Snowflake's architecture?

    <p>OLAP cube service</p> Signup and view all the answers

    Which two file formats are recognized by Snowflake for semi-structured data?

    <p>JSON and Parquet</p> Signup and view all the answers

    Which two factors are the primary drivers of Snowflake's pricing model?

    <p>Amount of data stored and amount of compute used</p> Signup and view all the answers

    What is one advantage of using the time travel feature in Snowflake?

    <p>To quickly recover from dropping a table</p> Signup and view all the answers

    Which languages can be utilized to interact with Snowflake?

    <p>SQL, Python, and Java</p> Signup and view all the answers

    What is the main purpose of Snowflake Database Replication?

    <p>To replicate data across different clouds/regions for DR</p> Signup and view all the answers

    Which feature is used for implementing Change Data Capture on a Snowflake table?

    <p>Streams</p> Signup and view all the answers

    What is a Snowflake Stage?

    <p>An object for referencing an external or internal cloud bucket</p> Signup and view all the answers

    What's the maximum configurable window for Time Travel?

    <p>90 days</p> Signup and view all the answers

    What’s the main reason that a Multi-Cluster Warehouse will scale out?

    <p>Increasing query queueing</p> Signup and view all the answers

    What is a cloud provider availability zone?

    <p>A physical data center</p> Signup and view all the answers

    To execute a Snowflake analytic query without fully qualified object names, what context needs to be provided?

    <p>Role</p> Signup and view all the answers

    What is the name of Snowflake’s Command Line Client?

    <p>SnowSQL</p> Signup and view all the answers

    What is an effective way to establish a hierarchy of Role Based Access Control roles in Snowflake?

    <p>GRANT one role to another role</p> Signup and view all the answers

    What does the term 'clustering' refer to in Snowflake?

    <p>Storing similar values together in micropartition files</p> Signup and view all the answers

    Which scaling strategy makes a single query run faster in Snowflake?

    <p>Increase the size of the virtual warehouse</p> Signup and view all the answers

    Which characteristic distinguishes a Snowpark-optimized virtual warehouse from a standard one?

    <p>Pre-loaded ML libraries</p> Signup and view all the answers

    When scaling a warehouse up, what must occur for the resize to be effective?

    <p>All query activity must finish before the resize</p> Signup and view all the answers

    How does Snowflake handle DML against a table?

    <p>It creates new micropartition files without editing existing ones</p> Signup and view all the answers

    Which Snowflake entity owns objects like tables, virtual warehouses, and databases?

    <p>A user ID</p> Signup and view all the answers

    What is the role of Snowpipe in data ingest jobs?

    <p>It allocates specific compute power for continuous data loading</p> Signup and view all the answers

    What determines the compute amount used by Snowpipe?

    <p>Snowpipe automatically determining the compute required</p> Signup and view all the answers

    What are two strengths of Snowflake’s governance and security model?

    <p>Granular permissions through Role Based Access Control</p> Signup and view all the answers

    Which features rely on the SnowGrid mechanism?

    <p>Cross-region and cross-cloud failover</p> Signup and view all the answers

    What is a main security advantage of using Snowflake’s LLM and machine learning capabilities?

    <p>Sensitive data is automatically masked in outputs from LLM or ML applications</p> Signup and view all the answers

    What does the term “data clean room” refer to?

    <p>A framework for privacy-preserving data sharing and analysis</p> Signup and view all the answers

    Which Snowflake feature allows customers to 'bring their own model' for AI/ML?

    <p>Snowpark Container Services</p> Signup and view all the answers

    What is the feature that enables customers to bring their own key for encryption?

    <p>KeyTrust</p> Signup and view all the answers

    Which built-in schema is relevant for querying credit consumption in a Snowflake account?

    <p>ACCOUNT_USAGE</p> Signup and view all the answers

    Study Notes

    SE Onboarding Product Knowledge Exam Study Guide

    • Exam format: Closed-book, 30 randomly selected questions from a pool of 50. 80% or above is passing.

    • Snowflake database type: Relational

    • Languages for interacting with Snowflake: SQL, Python, Java (All of the above)

    • Snowflake virtual warehouse: A compute cluster processing queries.

    • Data encryption: Uses SSL/TLS for data in transit and AES for data at rest

    • Data sharing feature: Sharing data within the same Snowflake account.

    • Snowflake architecture components: Database storage, Query processing engine, OLAP cube service, and Metadata repository.

    • Supported semi-structured file formats: JSON, Parquet

    • Time travel feature use: Quickly recover from dropping a table. Also, tracking changes over a long time (> 6 months).

    • Snowflake pricing model factors: Amount of data stored, Amount of compute used.

    • Cloud provider tools integrating with Snowflake: AWS Glue, Google BigQuery, Microsoft Azure Data Factory, AWS Redshift

    • Snowflake access control framework: Role-based access control (RBAC)

    • Snowflake data type for semi-structured data: VARIANT

    • Snowflake edition for HIPAA and PCI compliance: Business Critical Edition

    • Snowflake storage benefits: High availability and durability, Inexpensive storage.

    • Granting permissions: Grant SELECT or USAGE permissions on schema and table

    • System-defined roles: ACCOUNTADMIN, ROLEADMIN, SYSADMIN, WAREHOUSEADMIN

    • Number of clusters in a multi-cluster warehouse: Unlimited

    • Virtual Warehouse scaling: Up and down is automatic

    • Snowflake data table operations: The files created when data is added to a table are Partitioned Files, Micro-Partition Files, and Object Storage Files.

    • Snowflake deployment: AWS, Google Cloud, Azure, Oracle Cloud

    • Data replication purpose: High Availability across Availability Zones and Data Backup with Snowflake account

    • Change Data Capture feature: Snowpipe

    • Snowflake Command Line Client: SnowSQL

    • Time Travel window: 90 days

    • Virtual Warehouse scaling reason: Query activity from users in a workload management group defined as “urgent”.

    • Snowflake compression and metadata collection: At the micropartition level

    • Role-based access control hierarchy: Users establish their own hierarchies

    • Data processing on Snowflake: Micropartition file edits when processing DML requests.

    • Scaling strategies for queries: Adjusting the virtual warehouse's auto-suspend configuration. Also, Increase the size of the virtual warehouse. Scaling policy to "STANDARD". Distributing across more warehouses.

    • Snowpark-optimized virtual warehouse characteristic: Higher virtual core count

    • Snowflake object ownership: User ID, role, a cloud provider identity (like an AWS IAM role)

    • Snowpipe data ingest job allocation compute: Depends on whether created as STANDARD or ECONOMY

    • Snowflake security and governance aspects: Granular permissions via Role-based Access Control, controls applied consistently regardless of access method, Snowflake employees administer database and table security.

    • Data clean room: Not defined in the text, but implied to be a privacy-preserving mechanism for data sharing/analysis.

    • Snowflake feature for custom models: Snowpark Container Services, Snowpark-optimized virtual warehouses

    • Data encryption key management: "Bring your own key" feature: Key Trust

    • Snowflake schema for credit consumption: METERING

    • Queries that don't need an active warehouse: DESCRIBE TABLE T1

    • Data pruning indicator: Percentage scanned from cache

    • Federated authentication: Snowflake oAuth

    • Collaboration related terms (3): Snowflake Marketplace, Auto Fulfillment, Search Optimization Service

    • Authentication provider: Microsoft Azure Active Directory

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    SE Onboarding Product Knowledge Exam PDF

    Description

    Prepare for your Snowflake database exam with this comprehensive knowledge quiz. Covering key concepts like Snowflake architecture, data encryption, and integration tools, this quiz will help you solidify your understanding of the platform. Test your skills against randomly selected queries to ensure you're ready for certification.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser