Ask Question
Snowflake COF-C02 Practice Test - Questions Answers, Page 18
List of questions
Question 171
What COPY INTO SQL command should be used to unload data into multiple files?
The COPY INTO SQL command with the optionSINGLE=FALSEis used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.References:SnowPro Core Certification COPY INTO SQL command unload multiple files
Question 172
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database.References:SnowPro Core Certification cloning database stored procedures views
Question 173
When loading data into Snowflake, how should the data be organized?
When loading data into Snowflake, it is recommended to organize the data into single files with 100-250 MB of compressed data per file. This size range is optimal for parallel processing and can help in achieving better performance during data loading operations.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 174
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a 'Recycle Bin' where they can be restored within a time limit before they are permanently deleted.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 175
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
The SQL statementSHOW GRANTS TO ROLE MY_ROLEis used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 176
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 177
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
To go back to the first version of a transient table created three days prior, one can use Time Travel if theDATA_RETENTION_TIME_IN_DAYSwas set to at least 3 days. This allows the user to access historical data within the specified retention period.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 178
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
The features associated with Continuous Data Protection (CDP) that require additional Snowflake-provided data storage are Time Travel and Fail-safe. Time Travel allows users to access historical data within a defined period, while Fail-safe provides an additional layer of data protection beyond the Time Travel period.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 179
Where can a user find and review the failed logins of a specific user for the past 30 days?
The LOGIN_HISTORY view in the ACCOUNT_USAGE schema provides information about login attempts, including both successful and failed logins. This view can be used to review the failed login attempts of a specific user for the past 30 days.References:[COF-C02] SnowPro Core Certification Exam Study Guide
Question 180
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Snowflake uses a Role-Based Access Control (RBAC) model to manage access to data and resources. Additionally, Snowflake ensures that all data is encrypted, both at rest and in transit, to provide a high level of security for data stored within the platform.References:[COF-C02] SnowPro Core Certification Exam Study Guide
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