Snowflake snowpro cert - Study guides, Class notes & Summaries

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 three layers of Snowflake, bottom to top? Database Stora...

What are the 3 Cloud Providers available for Snowflake correct answers1) 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) correct answersTrue How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data correct answersA) Multi-Cluster, Shared Data What are the 3 components of Snowflak...

Snowflake SnowPro Certification - Practice Exam Questions and Answers 100% Verified You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from the ...

Which file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows?: STRIP_OUTER_ARRAY DROP_OUTER_ARRAY UNSET_OUTER_ARRAY TRUNCATE_OUTER_ARRAY correct answers STRIP_OUTER_ARRAY (Correct) In general, JSON and Avro data sets are a simple concatenation of multiple documents. The JSON or Avro output from some software is composed of a single huge array containing multiple records. There is no nee...

You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 correct answersA, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from the roles given: A) ACCOUNTADMIN B) SYSADMIN C) AUDITOR D) ROLEADMI...

What are the 3 Cloud Providers available for Snowflake correct answers 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) correct answers True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data correct answers A) Multi-Cluster, Shared Data What are the 3 components of Snowf...

You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... A) Grant USAGE on D1 B) Grant SELECT on D1 C) Grant USAGE on S1 D) Grant SELECT on S1 E) Grant USAGE on T1 F) Grant SELECT on T1 correct answers A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from the roles given: A) ACCOUNTADMIN B) SYSADMIN C) AUDITOR D) ROLEADM...

True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. correct answersTrue True or False? Are Snowpipe charges calculated per second and per core? correct answersTrue What types of views are available in Snowflake? correct answersRegular, secure and materialized What character identifies a table stage? correct answers@% What are the types of internal stages? correct answersUser, table, internal named What character identifies a...

Snowflake SnowPro Certification Study Guide | updated 2024