- Guías de estudio, Notas de estudios & Resúmenes

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 páginas

Escrito en 2023/2024

Grado 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 páginas

Escrito en 2023/2024

Grado 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 páginas

Escrito en 2023/2024

Grado 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 páginas

Escrito en 2023/2024

Grado A+

KatelynWhitman

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

-

39 páginas

Escrito en 2022/2023

Grado 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 artículos

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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado 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 páginas

Escrito en 2022/2023

Grado A+

StuviaExamHub