Online Access Free COF-C01 Exam Questions

Which of the following is true of Snowpipe via REST API? Choose 2 answers

• A.you can only use it on internal Stages
• B.Snowflake automatically manages the compute required to execute the Pipe's copy into commands
• C.All COPY INTO options are available fluting pipe creation
• D.Snowpipe keeps track of which files it has loaded

Which of the following statements is true of data loading?

• A.The "deal file size for loading is 16MB to match micro-partition size
• B.Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast
• C.Marry files in the 10-lOOMB range tend to land In the 'sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

• A.JDBC
• B.SnowSQL
• C.Python
• D.ODBC
• E.Snowflake Web Interface (UI)

Which of the following statements describes a benefit of Snowflake's separation of compute and storage? (Choose all that apply.)

• A.Compute can be scaled up or down without the requirement to add more storage
• B.Storage expands without the requirement to add more compute
• C.Multiple compute clusters can access stored data without contention
• D.Growth of storage and compute are tightly coupled together

True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer's Snowflake account.

• A.False
• B.True