DEA-C02: SnowPro Advanced — Data Engineer

By Snowflake · Question Mode

QuestionQ18

VerifiedOfficial exam objectives/topics

A Data Engineer must replicate an internal stage that holds several files larger than 5 GB. The replication uses a directory table to ensure the file metadata is synchronized correctly.

What should the Engineer do to ensure successful replication of both the files and the directory table?

Explanation

For a replicated internal stage, the directory table is required to replicate its files, but a directory-table refresh fails if the stage contains a file larger than 5 GB. Before adding the database to a replication or failover group, disable the directory table on the primary stage, move the files larger than 5 GB to another stage without a directory table, and then re-enable the original directory table.

Learn more

Community Discussion

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