Configure Stages, File Formats, and Connectors DEA-C02 Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   Which SQL command is used to create a named internal stage in Snowflake?

   • ACREATE LOCATION
   • BCREATE INTERNAL STAGE
   • CCREATE STAGE
   • DCREATE DATABASE STAGE
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which authentication method is commonly used when configuring the Snowflake Connector for Kafka?

   • AOAuth
   • BKey-pair authentication
   • CUsername/password
   • DSAML SSO
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A COPY INTO command from an external stage fails with the error 'File format is not recognized'. The files in the stage are Parquet files. The stage was created without a file format, and the COPY INTO command does not specify one. What is the most likely cause and solution?

   • AThe stage URL is incorrect; verify the S3 bucket path.
   • BThe files are corrupted; re-upload the files to the stage.
   • CThe files have a .parquet extension but are actually CSV; rename the files.
   • DThe file format is not specified; add FILE_FORMAT = (TYPE = 'PARQUET') to the COPY INTO command.
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A data engineer is loading a CSV file where some fields are enclosed in double quotes and contain commas within the quoted text. The current COPY INTO command fails because the commas inside the quotes are being treated as field delimiters. Which file format option should be set to handle this correctly?

   • ARECORD_DELIMITER = '\n'
   • BFIELD_OPTIONALLY_ENCLOSED_BY = '"'
   • CFIELD_DELIMITER = ','
   • DNULL_IF = ('')
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A data engineer needs to load daily CSV exports from an internal reporting system into a table. The files are staged in an S3 bucket that is only accessible to the engineering team. The data must be loaded by a nightly task that runs under the ANALYST role, which should not have direct access to the S3 bucket. What is the most appropriate way to configure the stage and load the data?

   • AUse the COPY INTO command with the S3 URL directly and provide the AWS credentials in the command, then grant the ANALYST role EXECUTE on the COPY INTO command.
   • BCreate an external stage pointing to the S3 bucket, grant the ANALYST role USAGE on the stage, and reference the stage in the COPY INTO statement.
   • CCreate a user stage for the engineer who owns the files, and have the ANALYST role use the COPY INTO command with the user stage name.
   • DCreate a table stage and grant the ANALYST role the USAGE privilege on the table, then reference the table stage in the COPY INTO statement.
   Reveal Solution Discussion Select an answer first