Sno - Study guides, Class notes & Summaries

Snowflake SnowPro Certification Prep Questions and Answers Already Passed How many times can a share be consumed by a single account? Once. "A share can only be consumed once per account." What is Federated Authentication? Federated Authentication enables users to connect using SSO via an external SAML 2.0 compliment identity provider (IdP). What is the defn of PaaS? Platform as a Service. You manage only the applications and data. Everything else is managed by the vendor. What are the thr...

Snowflake SnowPro Certification Prep – Qs & As

Netguru - Snowflake SnowPro Certification Preparation Set – Qs & As

Snowflake Snowplow Certification Study Guide Questions and Answers 100% Correct What are the 3 Cloud Providers available for Snowflake 1) AWS - a provider since inception 2) Azure Cloud Platforms - generally available as of Sept. 2018 3) Google Cloud Platform - trialed late 2019 Snowflake is currently the only DW built for the cloud (T/F) True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data A) Multi-Cluster, Shared Data What are th...

Every Week correct answers Snowflake deploy new release at what frequency? Cluster the Transactions table on the transaction data column. The daily report will only access one day at a time and therefore will only scan required data correct answers You are the data modeler at a large retail organization who store their transactional data in a Snowflake table called "Transactions". The daily revenue reports execute using the "Transactions" table and calculates the revenue for the current d...

SnowPro Core Exam Study Guide: Questions

Snowflake SnowPro Certification Prep |194 Questions| With Complete Solutions.

What is the best way to store semi-structured data? correct answers Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? correct answers Create a Snowflake view that parse the semi-structured column into structure columns for the BI tool to retrieve True or False: Micro-partitions are immutable? correct answers True - subsequent changes of any type to the data will be written to additional micro-parti...

Cloud services layer correct answers Brain layer. Manages everything Query planning, optimization, compilation What is performed by the cloud services layer? correct answers Metadata management, storage Data security User authentication Compute layer correct answers Processing layer, virtual warehouses layer Storage layer correct answers data layer Associated with compute layer correct answers query processing Snowflake features correct answers Storage can scale up and down wit...

Snowflake SnowPro Certification Quiz – Q&A