Snowflake snowpro cert - Study guides, Class notes & Summaries

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

Snowflake Snowpro Core Certification – Q&A

Snowflake SnowPro Certification Study Guide Questions and Answers Graded A+ 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 ar...

Snowflake SnowPro Certification - Practice Exams Questions With Solutions 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 - ANS A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from...

Snowflake SnowPro Certification Study Guide Questions With 100% Correct Answers.

Snowflake SnowPro Certification Study Guide Exam Questions And Answers What are the 3 Cloud Providers available for Snowflake - ANS 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) - ANS True How does Snowflake describe their architecture? A) Multi-Cluster, Shared Data B) Single-Cluster, Shared Data - ANS A) Multi-Cl...

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

What object do you need to create to fetch data from private cloud locations? A. Storage Integration B. Only Stage C. Nothing, just pass source URL to a query D. Storage Connection correct answers A. Storage Integration What parameter should be changed to modify table retention time? A. DATA_RETENTION B. DATA_RETENTION_TIME_IN_DAYS C. DATA_RETENTION_TIME D. DATA_RETENTION_PERIOD correct answers B. DATA_RETENTION_TIME_IN_DAYS If a user has the role ACCOUNTADMIN assigned it's a...

Snowflake SnowPro Certification Study Guide Exam – Q’s and A’s

Snowflake SnowPro Certification Study Guide Exam – Q’s and A’s