| Exam Name: | SnowPro Core Certification Exam | ||
| Exam Code: | COF-C02 Dumps | ||
| Vendor: | Snowflake | Certification: | SnowPro Core Certification |
| Questions: | 941 Q&A's | Shared By: | arlen |
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Options:
There is no need to have a Snowflake account in the target region, a share will be created for each user.
The listing is replicated into all selected regions automatically, the data is not.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
Shares attached to listings in remote regions can be viewed from any account in an organization.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Answer:
B, CExplanation:
When publishing a Snowflake Data Marketplace listing into a remote region, it’s important to note that while the listing is replicated into all selected regions automatically, the data itself is not. Therefore, the data must be replicated separately. Additionally, the user must have the ORGADMIN role in at least one account to manage the replication of accounts1.
Which command can be used to load data files into a Snowflake stage?
Options:
JOIN
COPY INTO
PUT
GET
Answer:
CExplanation:
The PUT command is used to load data files into a Snowflake stage. This command uploads data files from a local file system to a specified stage in Snowflake
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?
Options:
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
The transient table version cannot be retrieved after 24 hours.
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
Answer:
AExplanation:
To go back to the first version of a transient table created three days prior, one can use Time Travel if the DATA_RETENTION_TIME_IN_DAYS was 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
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
Options:
Use the DROP
Specify the TEMPORARY option when creating the file format.
Specify the PURGE copy option in the COPY INTO
