SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ106

Ingest and Process Data

A Data Engineer must create a stage to ingest files from a Customer Relationship Management (CRM) system.

The stage must meet these requirements:

  1. Use an internal named stage with separate folders that serve as repositories for the files.
  2. Encrypt files through the cloud service hosting the Snowflake account when they arrive on the stage.
  3. Query the files later by using pre-signed URLs.
  4. Query metadata listing all unstructured files on the stage.

Which statement meets these requirements?

Explanation

An internal stage configured with ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE') encrypts files server-side when they arrive in the cloud service hosting the Snowflake account and supports pre-signed URL access. Enabling DIRECTORY creates a directory table that catalogs staged files and can be queried for unstructured-file metadata. Omitting a storage URL makes the named stage internal. Snowflake CREATE STAGE documentation Snowflake unstructured-data documentation

Learn more

Community Discussion

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