SnowPro-Core Free Practice Test

- (Exam Topic 3)
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

1. A. Use auto-ingest Snowpipes to load large files in a serverless model.
2. B. Produce the largest files possible, reducing the overall number of files to process.
3. C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
4. D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Correct Answer: B

- (Exam Topic 3)
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

1. A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
2. B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
3. C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
4. D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Correct Answer: C

- (Exam Topic 2)
What can be used to view warehouse usage over time? (Select Two).

1. A. The load HISTORY view
2. B. The Query history view
3. C. The show warehouses command
4. D. The WAREHOUSE_METERING HISTORY View
5. E. The billing and usage tab in the Snowflake web Ul

Correct Answer: DE

- (Exam Topic 3)
When cloning a database, what is cloned with the database? (Choose two.)

1. A. Privileges on the database
2. B. Existing child objects within the database
3. C. Future child objects within the database
4. D. Privileges on the schemas within the database
5. E. Only schemas and tables within the database

Correct Answer: BE

- (Exam Topic 1)
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

1. A. All Snowflake sessions using the warehouse are terminated.
2. B. The last query using the warehouse completes.
3. C. There are no users loaned into Snowflake.
4. D. The Warehouse is inactive for a specified period of time.

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html