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

Questions 11–15

1. 11foundation · easy

   Which statement correctly differentiates internal stages from external stages in Snowflake?

   • AInternal stages store data in Snowflake-managed storage; external stages reference data in customer-managed cloud storage.
   • BExternal stages are faster for loading data because they use Snowflake's internal network.
   • CInternal stages are only for temporary files; external stages are for permanent files.
   • DInternal stages require a named stage object; external stages do not.
   Reveal Solution Discussion Select an answer first
2. 12application · easy

   A Snowflake administrator created an internal named stage for the marketing team. The marketing role needs to load data from this stage, but the administrator wants to prevent the marketing role from modifying the stage definition. What privilege should the administrator grant to the marketing role?

   • AUSAGE on the stage
   • BOWNERSHIP on the stage
   • CREAD on the stage
   • DWRITE on the stage
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which clause in a COPY INTO command specifies the file format to use when loading data?

   • AFORMAT = (TYPE = 'CSV')
   • BFILE_FORMAT = (FORMAT_NAME = 'my_format')
   • CSTAGE_FILE_FORMAT = 'my_format'
   • DTYPE = 'CSV'
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which SQL statement grants the ability to write files to a stage to the role 'loader'?

   • AGRANT USAGE ON STAGE my_stage TO ROLE loader;
   • BGRANT WRITE ON my_stage TO ROLE loader;
   • CGRANT WRITE ON STAGE my_stage TO ROLE loader;
   • DGRANT INSERT ON STAGE my_stage TO ROLE loader;
   Reveal Solution Discussion Select an answer first
6. 15expert · medium

   A Snowflake administrator needs to create a stage that will be used by multiple teams. The administrator wants to ensure that each team can only access its own subdirectory within the stage. What should the administrator do?

   • ACreate a separate named stage for each team and grant USAGE on each stage to the respective team.
   • BCreate a single named stage and grant USAGE to all teams, relying on the directory structure within the stage.
   • CCreate a single named stage and use directory table to restrict access.
   • DCreate a single named stage and grant OWNERSHIP to all teams.
   Reveal Solution Discussion Select an answer first