Configure Stages and File Formats COF-C03 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which SQL command removes a stage object and its associated metadata from Snowflake?

   • ADROP STAGE my_stage
   • BREMOVE STAGE my_stage
   • CDELETE STAGE my_stage
   • DALTER STAGE my_stage DROP
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which SQL command creates a new named internal stage in Snowflake?

   • ACREATE NAMED STAGE my_stage
   • BCREATE OR REPLACE STAGE my_stage
   • CCREATE INTERNAL STAGE my_stage
   • DCREATE STAGE my_stage
   Reveal Solution Discussion Select an answer first
4. 8application · easy

   A team is loading CSV files that contain dates in the format 'YYYY-MM-DD'. The team wants to ensure that the dates are interpreted correctly during the load. What file format option should be set?

   • ACOMPRESSION = 'GZIP'
   • BENCODING = 'UTF-8'
   • CDATE_FORMAT = 'YYYY-MM-DD'
   • DTIMESTAMP_FORMAT = 'YYYY-MM-DD'
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which privilege allows a role to list and read files from a stage in Snowflake?

   • AOWNERSHIP
   • BUSAGE
   • CREAD
   • DWRITE
   Reveal Solution Discussion Select an answer first
6. 10application · easy

   A data analyst wants to load a single CSV file from their local machine into a Snowflake table. The analyst does not have access to any external cloud storage. What is the most efficient way to load this file?

   • AUse the PUT command to upload the file to a user stage, then use COPY INTO to load it.
   • BUse the COPY INTO command directly with the local file path.
   • CUse the GET command to upload the file to a table stage.
   • DCreate an external stage pointing to the local machine.
   Reveal Solution Discussion Select an answer first