Question 241 · 1323 in bank
When creating a virtual warehouse, what setting should be used to avoid both over-provisioning resources and auto-scaling when there is increased concurrency?
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
When creating a virtual warehouse, what setting should be used to avoid both over-provisioning resources and auto-scaling when there is increased concurrency?
Answer: C
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
Answer: B
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.
Source: Adapted from community discussion — arpit_dataguy
What is the MINIMUM Snowflake edition required to add masking policies to selectively mask plain-text data in a table or in view columns at query time?
Answer: B
To add masking policies and selectively mask plain-text data in a table or view column at query time in Snowflake, you need at least the Enterprise Edition. Explanation: This feature, known as "Dynamic Data Masking", is only available on the Enterprise Edition and higher tiers of Snowflake. Key points about Snowflake masking policies: Feature: Dynamic Data Masking Required Edition: Enterprise Edition or higher Functionality: Allows you to create masking policies that selectively hide sensitive data in columns when queried, without modifying the underlying data.
Source: Adapted from community discussion — c561a14
What does Snowflake recommend when configuring the auto-suspend parameter for a virtual warehouse?
Answer: C
Which URL type should be used for custom applications that need to access unstructured data files?
Answer: B
When would creating and using a standard view be preferable to using a materialized view?
Answer: D
When using a direct share, what privileges does a role need to control access to the objects that are in a share that is using database roles? (Choose two.)
Answer: DE
What actions can be performed by consumers of shared databases? (Choose two.)
Answer: C
A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user. What will Snowflake do if the user's IP address does not match the user-level network policy rules?
Answer: C
Per Snowflake's documentation - In addition, when a user-level network policy is associated with the user and the user is already logged into Snowflake, if the user’s network location does not match the user-level network policy rules, Snowflake prevents the user from executing further queries. - https://docs.snowflake.com/en/user-guide/network-policies
Source: Adapted from community discussion — c561a14
True or False: A Virtual Warehouse can be resized while suspended.
Answer: A
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 241. 1323 questions available.
Version 1.0.0. How we source questions