| Exam Name: | SnowPro Core Certification Exam | ||
| Exam Code: | COF-C02 Dumps | ||
| Vendor: | Snowflake | Certification: | SnowPro Core Certification |
| Questions: | 948 Q&A's | Shared By: | presley |
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
Options:
list @mytable;
list @%raytable;
list @ %m.ystage;
list @mystage;
Answer:
DExplanation:
The command list @mystage; is used to view the list of files that have been uploaded to an internal stage in Snowflake. The list command displays the metadata for all files in the specified stage, which in this case is mystage. This command is particularly useful for verifying that files have been successfully unloaded from a Snowflake table to the stage and for managing the files within the stage.
What can be used to view warehouse usage over time? (Select Two).
Options:
The load HISTORY view
The Query history view
The show warehouses command
The WAREHOUSE_METERING__HISTORY View
The billing and usage tab in the Snowflake web Ul
Answer:
B, DExplanation:
To view warehouse usage over time, the Query history view and the WAREHOUSE_METERING__HISTORY View can be utilized. The Query history view allows users to monitor the performance of their queries and the load on their warehouses over a specified period1. The WAREHOUSE_METERING__HISTORY View provides detailed informationabout the workload on a warehouse within a specified date range, including average running and queued loads2. References: [COF-C02] SnowPro Core Certification Exam Study Guide
User-level network policies can be created by which of the following roles? (Select TWO).
Options:
ROLEADMIN
ACCOUNTADMIN
SYSADMIN
SECURITYADMIN
USERADMIN
Answer:
B, DExplanation:
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
Which of the following can be executed/called with Snowpipe?
Options:
A User Defined Function (UDF)
A stored procedure
A single copy_into statement
A single insert__into statement
Answer:
CExplanation:
Snowpipe is used for continuous, automated data loading into Snowflake. It uses a COPY INTO