SnowPro Advanced: Architect — Question 178

PDF files are being ingested into a Snowflake environment. The files will be staged and processed into tables later. The data will be shared directly using software links to the PDF files, with server-side encryption enabled.

How should these PDF files be ingested while creating a catalog of staged files, using server-side encryption?

Answer options

• A. Create a Python User-Defined Function (UDF) to process the PDF files into tables.
• B. CREATE STAGE invoices_pdf_stage - ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE');
• C. CREATE STAGE invoices_pdf_stage - ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE') DIRECTORY = ( ENABLE = true );
• D. CREATE STAGE my_stage URL = 's3://bucketname/PDFs/' CREDENTIALS = (AWS_KEY_ID = 'xxyyzz' AWS_SECRET_KEY = 'zzyyxx');

Correct answer: C

Explanation

The correct answer is C because it allows for the creation of a stage with both server-side encryption and the ability to enable a directory for cataloging staged files. Option A focuses on using a Python UDF, which does not address the staging and encryption requirements. Option B does not enable the directory feature, and Option D specifies a URL stage but lacks the necessary encryption settings.