Snowflake snowpro core Study guides, Class notes & Summaries

Snowflake Snowpro Core Certification – Q&A

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

True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. correct answers True True or False? Are Snowpipe charges calculated per second and per core? correct answers True What types of views are available in Snowflake? correct answers Regular, secure and materialized What character identifies a table stage? correct answers @% What are the types of internal stages? correct answers User, table, internal named What character identif...

Which file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows?: STRIP_OUTER_ARRAY DROP_OUTER_ARRAY UNSET_OUTER_ARRAY TRUNCATE_OUTER_ARRAY correct answers STRIP_OUTER_ARRAY (Correct) In general, JSON and Avro data sets are a simple concatenation of multiple documents. The JSON or Avro output from some software is composed of a single huge array containing multiple records. There is no nee...

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, secure and materialized What character identifies a table stage? correct answers@% What are the types of internal stages? correct answersUser, table, internal named What character identifies a...

True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. correct answers True True or False? Are Snowpipe charges calculated per second and per core? correct answers True What types of views are available in Snowflake? correct answers Regular, secure and materialized What character identifies a table stage? correct answers @% What are the types of internal stages? correct answers User, table, internal named What character identif...

Which file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows?: STRIP_OUTER_ARRAY DROP_OUTER_ARRAY UNSET_OUTER_ARRAY TRUNCATE_OUTER_ARRAY correct answers STRIP_OUTER_ARRAY (Correct) In general, JSON and Avro data sets are a simple concatenation of multiple documents. The JSON or Avro output from some software is composed of a single huge array containing multiple records. There is no nee...

Snowflake SnowPro-Core Certification Exam Questions And Answers True or False: Snowflake charges additional fees to Data providers for each share they create. - ANS 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? - ANS 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 you consider disabling aut...

Snowflake SnowPro-Core Certification Exam

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