COF-C02 exam

What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMIN B. ORGADMIN C. SECURITYADMIN D. SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Where would a Snowflake user find information about query activity from 90 days ago?A . account__usage . query history view B. account__usage.query__history__archive View C. information__schema . cruery_history view D. information__schema - query history_by_ses s i on viewView AnswerAnswer: B

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters...

The fail-safe retention period is how many days?A . 1 day B. 7 days C. 45 days D. 90 daysView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of values B. Micro-partitions are immutable objects that support the use of Time Travel. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses D. Rows are automatically stored...

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...

Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY command B. Updating data C. Snowpipe D. AUTOMATIC__CLUSTERING E. Scaling up a warehouseView AnswerAnswer: A, D

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: D

Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimum B. Credits are used to pay for cloud data storage usage C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs D. Credits are consumed...