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

Questions 11–15

1. 11foundation · easy

   Which SQL command is used to remove a stage from Snowflake?

   • ADROP STAGE
   • BALTER STAGE ... DELETE
   • CDELETE STAGE
   • DREMOVE STAGE
   Reveal Solution Discussion Select an answer first
2. 12application · easy

   A data engineer needs to load Avro files into a Snowflake table. The Avro files contain a schema that includes nested records. The engineer wants to store the data in a VARIANT column to preserve the nested structure. Which file format should be used in the COPY INTO command?

   • ATYPE = 'JSON'
   • BTYPE = 'PARQUET'
   • CTYPE = 'AVRO'
   • DTYPE = 'CSV'
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which file format type is columnar and optimized for analytical queries?

   • AJSON
   • BParquet
   • CAvro
   • DCSV
   Reveal Solution Discussion Select an answer first
5. 14application · easy

   A data engineer created an external stage for a project. The project is being decommissioned, and the stage is no longer needed. The engineer wants to remove the stage and all associated metadata. Which SQL command should be used?

   • ADELETE STAGE my_stage;
   • BREMOVE STAGE my_stage;
   • CALTER STAGE my_stage SET ENABLED = FALSE;
   • DDROP STAGE my_stage;
   Reveal Solution Discussion Select an answer first
6. 15expert · medium

   A company is setting up the Snowflake Connector for Kafka to stream data from multiple topics into separate tables. The connector runs on a single EC2 instance. The data engineer needs to ensure that the connector can handle high throughput without losing data. Which configuration approach is most appropriate?

   • AConfigure a single connector instance with multiple tasks, each handling a subset of partitions.
   • BIncrease the buffer size and batch size in the connector configuration to maximize throughput.
   • CUse the Snowflake Connector for Spark instead, as it provides better throughput.
   • DRun multiple connector instances on the same EC2 instance, each handling a different topic.
   Reveal Solution Discussion Select an answer first