Question 61 · 1323 in bank
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
Show answer
Answer: C
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
According to best practices, which table type should be used if the data can be recreated outside of Snowflake?
Answer: C
Which function unloads data from a relational table to JSON?
Answer: D
What is the purpose of the STRIP_NULL_VALUES file format option when loading semi-structured data files into Snowflake?
Answer: D
Which Snowflake edition enables data sharing only through Snowflake Support?
Answer: A
What is the primary purpose of partitioning staged data files for regular data loads?
Answer: A
https://docs.snowflake.com/en/user-guide/data-load-considerations-manage Note "S3 transmits a directory list with each COPY statement used by Snowflake, so reducing the number of files in each directory improves the performance of your COPY statements. You may even consider creating subfolders of 10-15 minute increments within the folders for each hour." --reducing the number of files in each directory improves the performance of your COPY statements. meaning more partition, better the performance.
Source: Adapted from community discussion — JRayan
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Answer: C
"Business Critical Edition, formerly known as Enterprise for Sensitive Data (ESD), offers even higher levels of data protection to support the needs of organizations with extremely sensitive data, particularly PHI data that must comply with HIPAA and HITRUST CSF regulations." https://docs.snowflake.com/en/user-guide/intro-editions
Source: Adapted from community discussion — Jacobr5000
What can a Snowflake user do to reduce queuing on a multi-cluster virtual warehouse?
Answer: C
Which statements describe benefits of Snowflake's separation of compute and storage? (Choose two.)
Answer: AE
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
Answer: B
False. There are no storage charges for external stages billed through Snowflake. We need to pay the external vendor directly and not to the snowflake.
Source: Adapted from community discussion — arpit_dataguy
What should be used to show the status of partial data loads and loading errors?
Answer: A
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 61. 1323 questions available.
Version 1.0.0. How we source questions