B snowflake - Study guides, Class notes & Summaries

D - Snowflake Level Up Step 5 Questions and Answers Rated A What are the 4 Snowflake table types? Permanent External Temporary Transient Which of the following are Snowflake view types? Secure Permanent External Standard Materialized Transient Secure Standard Materialized What are the three Snowflake Stage types? Secure Permanent User Materialized Table Named User Table Named Named stages come in two varieties, what are they? Internal and External Which type of view is most like a ...

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage ...

Snow-pro Core Certification Exam Questions & Answers, RATED A+ SnowPro Core Certification Exam COF-C02 - -The SnowPro Core Certification demonstrates an individual's knowledge to apply specific core expertise implementing and migrating to Snowflake. A SnowPro Core Certified individual has a thorough understanding of the Snowflake Cloud Data Platform, and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives. Exam I...

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

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

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

Phases in Data Analytics - Data requirement gathering - Data source identification - Data cleaning - Data processing - Exploratory data analysis Types of Analytics - Descriptive analytics - Diagnostic analytics - Predictive analytics - Cognitive analytics - Prescriptive analytics Roles in data science - Data analyst - Business analyst - Data engineer - Data scientist - Database admin Data analyst - jack of all traits - PowerBI (minimal/no code) - PM / stake...

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

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

What alternate term is associated with the Compute/Warehouse layer? correct answersQuery Processing If you find a data-related tool that is not listed as part of the Snowflake ecosystem, what industry standard options could you check for as a way to easily connect to Snowflake? correct answersCheck to see if the tool can connect to other solutions via ODBC; Check to see if the tool can connect to other solutions via JDBC Which roles can create network policies? correct answersACCOUNTADMI...