- Study guides, Class notes & Summaries

Snowflake Certification study guide already graded A 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 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following terms best describes Snowflake's data...

-

36 pages

Written in 2023/2024

Grade A+

StellarScores

Snowflake Certification Questions and Answers Already Passed True or False: Data Storage is independent from compute? True True or False: All virtual warehouses have access to all data? True True or False: Al interactions with data are initialized through the services layer? True True or False: Multi-Cluster Warehouses support high concurrency? True True or False: Warehouses can be dynamically expanded to adjust to workloads? True Which layer provides centralized services for the data wareh...

-

61 pages

Written in 2023/2024

Grade A+

StellarScores

True or False: Data Storage is independent from compute? True True or False: All virtual warehouses have access to all data? True True or False: Al interactions with data are initialized through the services layer? True True or False: Multi-Cluster Warehouses support high concurrency? True True or False: Warehouses can be dynamically expanded to adjust to workloads? True Which layer provides centralized services for the data warehouse? Cloud Services ...

-

37 pages

Written in 2023/2024

Grade A+

QUILLSKY

Snowflake Certification Test With Complete Solution True or False: Data Storage is independent from compute? - ANSWERTrue True or False: All virtual warehouses have access to all data? - ANSWERTrue True or False: Al interactions with data are initialized through the services layer? - ANSWERTrue True or False: Multi-Cluster Warehouses support high concurrency? - ANSWERTrue True or False: Warehouses can be dynamically expanded to adjust to workloads? - ANSWERTrue Which layer provides central...

-

39 pages

Written in 2023/2024

Grade A+

KatelynWhitman

Snowflake Certification Exam Complete Questions & Answers 2023 (100% correct).

-

39 pages

Written in 2022/2023

Grade A+

GeekBano

1 Exam (elaborations) Snowflake Certification Questions and answers rated A+ (fully solved) 2 Exam (elaborations) Snowflake SnowPro Core Certification question and answers 2023 graded A+ 3 Exam (elaborations) Snowflake Certification question with complete solution 2023 graded A+ 4 Exam (elaborations) Snowflake Certification study guide question

-

21 items

StuviaExamHub

Snowflake Certification Questions and answers rated A+ (fully solved) 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 answer A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue ho...

-

23 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Snowflake SnowPro Core Certification question and answers 2023 graded A+True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. - correct answer True True or False? Are Snowpipe charges calculated per second and per core? - correct answer True What types of views are available in Snowflake? - correct answer Regular, secure and materialized What character identifies a table stage? - correct answer @% What are the types of internal s...

-

11 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Snowflake Certification question with complete solution 2023 graded A+Data Storage is _______ from compute (1) - correct answer independent COMPUTE clusters are predefined by _______ and ________ cloud services - correct answer AWS and Azure True or False: The SYSADMIN role is managed by the ACCOUNTADMIN role. - correct answer True True or False: All virtual warehouses have access to all data? - correct answer True True or False: All interactions with data are initialized thro...

-

39 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Snowflake Certification study guide question and answers latest 2023 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 answer 1) Adds clusters automatically based on query activity 3) Scales down when query activity slows Which of the following t...

-

27 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Snowflake SnowPro-Core Certification Exam correctly answered 2023(graded A+)True or False: Snowflake charges additional fees to Data providers for each share they create. - correct answer A. True B. False Answer: A A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables? - correct answer A. The tables are now orphaned B. The user that deleted the role C. SYSADMIN D. The assumed role that dropped the role Answer: D When should yo...

-

3 pages

Written in 2022/2023

Grade A+

StuviaExamHub

SnowPro Exam Certification Prep 5 question and answers rated A+ 2023 (fully solved)True or false: Snowflake supports defining and maintaining constraints, but does not enforce them - correct answer True Which other data types are treated as VARCHAR "under the covers" by Snowflake? - correct answer Text, String, Char, Varchar True or false: New Releases do not include any bug fixes - correct answer False True or false: Snowflake is designed to load small volumes of frequent data - corr...

-

8 pages

Written in 2022/2023

Grade A+

StuviaExamHub

B - Snowflake Level Up Step 1-2 question & answers graded A+ 2023Which of the following terms are associated with the Cloud Services Layer? Query Processing Query Planning Query Optimization Query Design Query Compilation - correct answer Query Planning Query Optimization Query Compilation Which of the following terms are associated with the Compute/Warehouse Layer? Query Processing Query Planning Query Optimization Query Design Query Compilation - correct answer Query Processing...

-

6 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Udemy Snowpro Core Certification - Practice Questions Test 5 question and answers 2023Which of the following semi-structured file formats are supported by Snowflake? - correct answer - XML - Parquret - JSON The load metadata for a table expires after how many days? - correct answer 64 t/f Is snowpipe serverless? - correct answer True Which of the following statements are true for Snowpipe? - correct answer - Snowpipe uses servless compute resources managed by Snowflake - The resource...

-

4 pages

Written in 2022/2023

Grade A+

StuviaExamHub

SnowPro Core Certification COF-C02 Study Guides fully solved 2023SnowPro Core Certification Exam COF-C02 - correct answer 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. ...

-

2 pages

Written in 2022/2023

Grade A+

StuviaExamHub

SnowPro Certification correctly answered to pass(rated A+)2023What is the best way to store semi-structured data? - correct answer Data should be loaded and stored in a VARIANT type column What is the best practice for handling semi-structured data with 3rd party BI tools? - correct answer Create a Snowflake view that parse the semi-structured column into structure columns for the BI tool to retrieve True or False: Micro-partitions are immutable? - correct answer True - subsequent changes ...

-

196 pages

Written in 2022/2023

Grade A+

StuviaExamHub

24 | Snowflake Query Optimization Service | SnowPro Certification Exam | COF-C02 fully solved 2023Check all the Snowflake Editions that have Search Optimization Service enabled? A. Standard B. Enterprise C. Business Critical D. VPS (Virtual Private Snowflake) - correct answer B, C, D Standard edition of Snowflake does not support search optimization service. Standard and higher support search optimization service. Search Optimization Service is a ________ level property. A. Column...

-

5 pages

Written in 2022/2023

Grade A+

StuviaExamHub

Snowflake SnowPro Certification - Practice Exams correctly answered 2023You 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 answer A, C and F Grant USAGE on D1, USAGE on S1 and SELECT on T1 Identify system-defined roles in Snowflake from...

-

20 pages

Written in 2022/2023

Grade A+

StuviaExamHub

SnowPro Certification Study Guide Part 1 question and answers 2023 rated A+Database Storage(Layer 3) - correct answer Responsible - Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format - Data objects stored by Snowflake are not directly visible nor accessible by customers - Manages all aspects of data(size,compression etc) Query Processing(Layer 2) - correct answer Queries are processed using Virtual Warehouses - Each warehouse is an MPP compute clu...

-

9 pages

Written in 2022/2023

Grade A+

StuviaExamHub

SnowPro Certification - On Demand Knowledge Check Questions and answers 2023 graded A+A year old database has DATA_RETENTION_TIME_IN_DAYS set to 90 days. The DATA_RETENTION_TIME_IN_DAYS is reset to 30 days. What happens to the data stored in time travel older than 30 days for this database? All data in time travel for this database will be deleted and new changes to the database will be kept for 30 days in time travel Reducing the number of days in DATA_RETENTION_TIME_IN_DAYS on a database...

-

8 pages

Written in 2022/2023

Grade A+

StuviaExamHub