SnowPro Core free question 5 / 10 · Domain 3: Data Loading, Unloading, and Connectivity
Which compute resources does bulk loading with the COPY command use?
- Compute resources of the cloud services layer
- Serverless compute provided by Snowflake
- Compute resources of the user's own computer
- A virtual warehouse specified by the user
Show the answer and explanation
Answer: D
Why this is correct
Bulk loading relies on user-provided virtual warehouses, which are specified in the COPY statement. Users are required to size the warehouse appropriately to accommodate expected loads.
Why the other options are wrong
"Serverless compute provided by Snowflake" … Serverless compute provided by Snowflake is what Snowpipe uses.
"Compute resources of the cloud services layer" … The cloud services layer does not run the load. A virtual warehouse does.
"Compute resources of the user's own computer" … Loading runs on a warehouse in Snowflake, not on the local machine.
Key point
Sizing the warehouse is the user's responsibility, which is a major difference from Snowpipe. The number of load operations that run in parallel cannot exceed the number of data files to be loaded.
Go to the SnowPro Core practice app (10 free questions; purchase unlocks all questions)