DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ35

VerifiedOfficial exam objectives/topics

A Data Engineer needs to create a stage for ingesting files from a Customer Relationship Management (CRM) system.

The stage must meet these requirements:

  1. Use an internal named stage with distinct folders that act as repositories for the files.
  2. Files must be encrypted by the cloud service hosting the Snowflake account when they arrive on the stage.
  3. The files will later be queried using pre-signed URLs.
  4. A metadata list of every unstructured file on the stage must be queryable.

Which statement meets these requirements?

Explanation

For an internal named stage, SNOWFLAKE_SSE provides server-side encryption by the cloud service hosting the Snowflake account and supports access through pre-signed URLs. Enabling DIRECTORY creates a directory table, which catalogs staged files and allows their metadata, including unstructured-file metadata, to be queried. A named internal stage can contain files in multiple relative-path folders. CREATE STAGE, Introduction to unstructured data

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!