OWP Study guides, Class notes & Summaries

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

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. Answer True True or False? Are Snowpipe charges calculated per second and per core? Answer True What types of views are available in Snowflake? Answer Regular, secure and materialized What character identifies a table stage? Answer @% What are the types of internal stages? Answer User, table, internal named What character identifies a user stage? Answer @~ What is the di...

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 Answer 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) ROLEADMIN E) SE...

True or False: A single database can exist in more than one Snowflake account. correct answersB. False A database is a logical grouping of schemas. Each database belongs to a single Snowflake account. Which of the following roles is recommended to be used to create and manage users and roles? A. SYSADMIN B. SECURITYADMIN C. PUBLIC D. ACCOUNTADMIN correct answersD. ACCOUNTADMIN By default, when your account is provisioned, the first user is assigned the ACCOUNTADMIN role. This user sho...

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

Udemy Snowpro Core Certification - Practice Questions Test 1 – Qs & As

SQL Standards Organization ANSI Transaction Compliance ACID Storage cost per terabyte $42 Service Layer Components (5) Authentication Infrastructure Management Metadata Security Transaction Manager Data Science Partners Sagemaker Dataiku Datarobot Account-level Objects (7) Network Policy User Role Database Warehouse Share Resource Monitor Schema-level Objects (8) Stage Pipe Procedure Function Table View Task Stream Namesp...