COF-R02

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.A . True B. FalseView AnswerAnswer: A Explanation: Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored. B. The replication will not be successful. C. The physical data is replicated D. Additional costs for storage are charged to a secondary account E. Metadata...

What is the default File Format used in the COPY command if one is not specified?A . CSV B. JSON C. Parquet D. XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html

The Query History in the Snowflake Web Interface (UI) is kept for approximately:A . 60 minutes B. 24 hours C. 14 days D. 30 days E. 1 yearView AnswerAnswer: C Explanation: Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

Which copy INTO command outputs the data into one file?A . SINGLE=TRUE B. MAX_FILE_NUMBER=1 C. FILE_NUMBER=1 D. MULTIPLE=FAISEView AnswerAnswer: A

True or False: Snowflake supports federated authentication in all editions.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://community.snowflake.com/s/news/federated-authentication-sso-now-available-in-all-snowflake-editions-MC6N3I63LJGNGMHCTKGKFDH4NH2Q

Which of the following terms best describes Snowflake’s database architecture?A . Columnar shared nothing B. Shared disk C. Multi-cluster, shared data D. Cloud-native shared memoryView AnswerAnswer: C Explanation: https://www.snowflake.com/product/architecture/ Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency...

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query time B. Partitions scanned is equal to partitions total C. An AggregateOperacor node is present D. The query...