Practice Exam

Explanations for each answer:

• Degree of copy parallelism is incorrect. Degree of copy parallelism controls how many concurrent connections are used to copy data in parallel, which can improve performance for large data transfers. While this setting can optimize copy speed, it's not required for copying from Snowflake to a Fabric warehouse. The essential configuration for this scenario is staging.
• Fault tolerance is incorrect. Fault tolerance settings allow the copy activity to skip incompatible rows during data transfer, such as rows that don't match the destination schema. While useful for handling data quality issues, fault tolerance is optional and not a requirement for copying data from Snowflake to a Fabric warehouse.
• Enable staging is correct. Enable staging is required when copying data from Snowflake to a Fabric warehouse. Staging uses an interim Azure Blob storage instance to enable the built-in staged copy process. When the destination data store or format isn't natively compatible with the Snowflake COPY command, staged copy provides better throughput by exporting data from Snowflake into staging storage, copying it to the destination, and then cleaning up temporary data. You need to configure an External Azure Blob Storage connection in the Settings tab for staging.
• Enable logging is incorrect. Enable logging captures detailed activity execution logs, including session logs, error files, and data consistency verification results. While logging is helpful for troubleshooting and auditing, it's optional and not required for the basic functionality of copying data from Snowflake to a Fabric warehouse.