Snowflake Certification bundled exams 2023 with 100% correct answers

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

Which of the following are true of Multi-cluster warehouses? Select all that apply. 1) Adds clusters automatically based on query activity 2) Sizes each cluster optimally based on the queries 3) Scales down when query activity slows 4) Multi-cluster warehouses will never auto-suspend correct an...

True or false: A table in Snowflake can contain both a variant columns and a timestamp. correct answersTrue True or false: The warehouse cache may be reset if a running warehouse is suspended and then resumed. correct answersTrue Which of the following are true of Multi-Cluster warehouses? Sel...

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

Which groups of SQL statements will run successfully in the Web UI? (Choose 2) -CREATE INDEX and DROP INDEX -CREATE USER, ALTER USER and DROP USER -CREATE TABLESPACE, ALTER TABLESPACE and DROP TABLESPACE -CREATE LOGFILE GROUP, ALTER LOGFILE GROUP and DROP LOGFILE GROUP -CREATE SERVER, ALTER SER...

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

Snowflake supports which of the following file formats for data loading? Select all that apply. Parquet ORC CSV PDF Parquet ORC CSV Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. Database Replication ELT ET...

Lateral and Table correct answersThe Flatten command will parse nested objects into separated rows. One version of the flatten command uses a join and other uses an object keyword. Select the two words that represent the option used with the flatten command. Flatten correct answersa table functio...

Which of the following terms are associated with the Cloud Services Layer? Query Processing Query Planning Query Optimization Query Design Query Compilation Query Planning Query Optimization Query Compilation Which of the following terms are associated with the Compute/Warehouse Layer...

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

What is Snowflake? (key features) correct answersAnalytic data warehouse SaaS offering - No hardware/installation/patching - No ongoing maintenance/tuning - Can't run privately (on-prem/hosted) Runs completely in the Cloud (AWS, Azure, GCP) - Has its own VPC Decoupled compute and stora...

Multi-cluster shared data correct answersWhich of the following terms best describes Snowflake's database architecture? Pruning correct answersWhat technique does Snowflake use to limit the number of micro-partitions scanned by each query? All data in Snowflake is encrypted correct answersWhi...

Check all the Snowflake Editions that have Search Optimization Service enabled? A. Standard B. Enterprise C. Business Critical D. VPS (Virtual Private Snowflake) correct answersB, C, D Standard edition of Snowflake does not support search optimization service. Standard and higher support se...