SOL-C01 Question #184: Real Exam Question with Answer & Explanation

Question

You have enabled auto-ingest using Snowpipe for a stage containing image files. You want to create a Directory Table to track the metadata of these image files (name, size, last modified time). After creating the Directory Table, you notice that it is not automatically updated when new image files are added to the stage. What steps should you take to ensure the Directory Table is automatically updated when new image files are added to the stage?

Options

• ASchedule a task to periodically refresh the Directory Table using the ALTER DIRECTORY
• BConfigure an event notification service (e.g., AWS SQS) to trigger a Snowpipe load whenever a
• CSet the 'directoryTableAutorefreshEnabled' parameter to TRUE at the account level using 'ALTER
• DDirectory Tables do not automatically refresh. You must always manually refresh them using the
• ESet the 'directoryTableAutorefreshEnabled' parameter to TRUE when creating or altering the stage

Explanation

To enable automatic refreshing of a Directory Table, you must set the 'directoryTableAutorefreshEnabled' parameter to TRUE at the account level. Also, you must refresh the directory table using 'ALTER DIRECTORY TABLE REFRESH' for the setting to take effect. Option A suggests using a scheduled task, but this is not the automatic way to refresh them. Option B refers to Snowpipe, which is related to data loading, not directly to Directory Table updates. Option D is incorrect as Directory Tables can be set to refresh automatically. Option E sets properties on the stage which is necessary, but not sufficient; the account level setting is

No community discussion yet for this question.