Free COF-C02 Exam Braindumps certification guide Q&A
COF-C02 Certification Overview Latest COF-C02 PDF Dumps
NEW QUESTION # 153
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
NEW QUESTION # 154
True or False: When you create a custom role, it is a practice to immediately grant that role
to ACCOUNTADMIN.
- A. True
- B. False
Answer: B
NEW QUESTION # 155
True or False: An active warehouse is required to run a COPY INTO statement.
- A. True
- B. False
Answer: A
NEW QUESTION # 156
Which of the following statements is true of data loading?
- A. The "deal file size for loading is 16MB to match micro-partition size
- B. Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
- C. Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
Answer: C
NEW QUESTION # 157
What is true about sharing data in Snowflake? (Choose two.)
- A. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
- B. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
- C. A Snowflake account can both provide and consume shared data.
- D. The Data Consumer pays only for compute resources to query the shared data.
- E. The Data Consumer pays for data storage as well as for data computing.
Answer: A,C
NEW QUESTION # 158
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Internal Stages
- B. Databases
- C. Users
- D. Tables
Answer: B,C,D
NEW QUESTION # 159
Which of the following describes the Snowflake Cloud Services layer?
- A. Manages quotas on the Snowflake account storage
- B. Coordinates activities in the Snowflake account
- C. Executes queries submitted by the Snowflake account users
- D. Manages the virtual warehouse cache to speed up queries
Answer: B
NEW QUESTION # 160
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
- A. MONITOR
- B. OPERATE
- C. MODIFY
- D. USAGE
Answer: B
NEW QUESTION # 161
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Optimized
- B. Standard
- C. Economy
- D. Custom
Answer: B,C
NEW QUESTION # 162
What is the maximum compressed row size in Snowflake?
- A. 8KB
- B. 16MB
- C. 4000GB
- D. 50MB
Answer: B
NEW QUESTION # 163
What is the default File Format used in the COPY command if one is not specified?
- A. CSV
- B. JSON
- C. XML
- D. Parquet
Answer: A
NEW QUESTION # 164
What are ways to create and manage data shares in Snowflake? (Select TWO)
- A. Through the enable__share=true parameter
- B. Through the DATA_SHARE=TRUE parameter
- C. Using the CREATE SHARE AS SELECT * TABLE command
- D. Through the Snowflake web interface (Ul)
- E. Through SQL commands
Answer: A,E
NEW QUESTION # 165
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Load files that are approximately 25 MB or smaller.
- B. Remove semi-structured data types
- C. Remove all dates and timestamps.
- D. Avoid using embedded characters such as commas for numeric data types
- E. Load files that are approximately 100-250 MB (or larger)
Answer: D,E
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 166
Which minimum Snowflake edition allows for a dedicated metadata store?
- A. Standard
- B. Enterprise
- C. Virtual Private Snowflake
- D. Business Critical
Answer: C
NEW QUESTION # 167
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
- A. Revoke all roles for functional managers and end users.
- B. Use secure materialized views.
- C. Use dynamic data masking.
- D. Use data encryption.
Answer: C
NEW QUESTION # 168
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
- A. A column with very high cardinality
- B. A VARIANT column
- C. A column that is most actively used in selective filters
- D. A column that is most actively used in join predicates
- E. A column with very low cardinality
Answer: C,D
NEW QUESTION # 169
Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
- A. RSA SecurlD Access
- B. Duo Security
- C. One Login
- D. Authy
Answer: B
NEW QUESTION # 170
What are value types that a VARIANT column can store? (Select TWO)
- A. OBJECT
- B. CLOB
- C. ARRAY
- D. BINARY
- E. STRUCT
Answer: A,C
Explanation:
Explanation
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics
NEW QUESTION # 171
What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?
- A. Business Critical Edition
- B. Premier
- C. Standard
- D. Enterprise
Answer: A
NEW QUESTION # 172
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning can be disabled within a Snowflake account
- B. Micro-partitioning has been known to introduce data skew
- C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- D. Micro-partitioning: requires a partitioning schema to be defined up front
Answer: C
NEW QUESTION # 173
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. REPLACE_INVALID_CHARACTERS
- B. SKIP_BYTE_ORDER_MARK
- C. STRIP_NULL_VALUES
- D. VALIDATION_MODE
Answer: D
Explanation:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 174
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
- A. Business Critical Edition
- B. Virtual Private Snowflake
- C. Enterprise Edition
- D. Custom Edition
- E. Standard Edition
Answer: A,B
NEW QUESTION # 175
......
The Best Snowflake COF-C02 Study Guides and Dumps of 2024: https://www.practicedump.com/COF-C02_actualtests.html
Top Snowflake COF-C02 Exam Audio Study Guide! Practice Questions Edition: https://drive.google.com/open?id=1gqDRuOSLjVO85GUoC80JY9ml3rozyP3H