Ask Question
Snowflake COF-C02 Practice Test - Questions Answers, Page 34
List of questions
Question 331
Which semi-structured data function interprets an input string as a JSON document that produces a VARIANT value?
The semi-structured data function that interprets an input string as a JSON document and produces a VARIANT value is PARSE_JSON.This function is used to parse a JSON formatted string and return it as a VARIANT data type, which can then be used for further processing within Snowflake3.
Question 332
Which items are considered schema objects in Snowflake? (Select TWO).
In Snowflake, schema objects include Pipes and File formats.Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake
Question 333
What are benefits of using Snowpark with Snowflake? (Select TWO).
Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake's virtual warehouses, eliminating the need for a separate cluster.Additionally, Snowpark's compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.
Question 334
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
Snowflake's billing for virtual warehouses is per-second, with a minimum of 60 seconds for each time the warehouse is started or resumed. Therefore, if a warehouse runs for 61 seconds, it is billed for 61 seconds.If it is then shut down and restarted, running for an additional 30 seconds, it is billed for another 60 seconds (the minimum charge for a restart), totaling 121 seconds2
Question 335
Which transformation is supported by a COPY INTO <table> command?
The COPY INTO <table> command in Snowflake supports transformations such as casting using a SELECT statement.This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table
Question 336
Which task privilege does a Snowflake role need in order to suspend or resume a task?
In Snowflake, the OPERATE privilege is required for a role to suspend or resume a task.This privilege allows the role to perform operational tasks such as starting and stopping tasks, which includes suspending and resuming them6
Question 337
Which role has the ability to create and manage users and roles?
The USERADMIN role in Snowflake has the ability to create and manage users and roles within the Snowflake environment.This role is specifically dedicated to user and role management and creation
Topic 4, Exam pool D
Question 338
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
In Snowflake, a user with the SECURITYADMIN role or higher can activate and enforce a network policy for all users in an account.Additionally, a role that has ownership of the network policy can also activate and enforce it
Question 339
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
In Snowflake, if a temporary table and a permanent table have the same name within the same schema, the temporary table takes precedence over the permanent table within the session where the temporary table was created4.
Question 340
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
The FLATTEN function can be used with the recursive argument to return a list of distinct key names in all nested elements within an object.This function is particularly useful for working with semi-structured data in Snowflake
Related questions
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question