Configure Stages and File Formats SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which type of stage in Snowflake is automatically created for each user and table, requiring no explicit creation command?

   • AInternal named stage
   • BUser and table stages
   • COnly user stages
   • DExternal stage
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A data analyst needs to load data from a file that is already in an S3 bucket. The bucket is owned by another team and they have provided an access key and secret key. What type of stage should they create?

   • AExternal stage with credentials
   • BUser stage
   • CTable stage
   • DInternal named stage
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   When creating an external stage in Snowflake, which parameter is required to specify the location of the files?

   • AURL
   • BCREDENTIALS
   • CENCRYPTION
   • DFILE_FORMAT
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A team uses a shared internal named stage for loading data. A new analyst needs to load files from this stage but should not be able to see or list other files in the stage. What should you do?

   • AGrant OWNERSHIP on the stage to the analyst's role.
   • BGrant READ on the stage to the analyst's role.
   • CCreate a separate stage for the analyst and grant USAGE on that stage.
   • DGrant USAGE on the stage to the analyst's role.
   Reveal Solution Discussion Select an answer first
6. 20expert · medium

   A company loads JSON files that contain a timestamp field in ISO 8601 format. They want to load this field into a TIMESTAMP column. What file format option should they configure?

   • ANULL_IF = ('NULL')
   • BDATE_FORMAT = 'YYYY-MM-DD'
   • CCOMPRESSION = GZIP
   • DTIMESTAMP_FORMAT = 'YYYY-MM-DD"T"HH24:MI:SS'
   Reveal Solution Discussion Select an answer first