Online Access Free COF-C01 Exam Questions

When loading data into Snowflake, the COPY command supports: Choose 2 answers

• A.Aggregates
• B.Joins
• C.Data type conversions
• D.Column reordering
• E.Fitters

Snowflake is designed for which type of workloads? (Choose two.)

• A.OLTP (Transactional) workloads
• B.OLAP (Analytics) workloads
• C.Concurrent workloads
• D.On-premise workloads

Which of the following statements would be used to export/unload data from Snowflake?

• A.INSERT INTO @stage
• B.EXPORT TO @stage
• C.COPY INTO @stage
• D.EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

• A.True
• B.False

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

• A.True
• B.False