File Info
| Exam | SnowPro Core Certification |
| Number | COF-C02 |
| File Name | Snowflake.COF-C02.VCEplus.2024-08-28.222q.vcex |
| Size | 625 KB |
| Posted | Aug 28, 2024 |
| Download | Snowflake.COF-C02.VCEplus.2024-08-28.222q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
What Snowflake role must be granted for a user to create and manage accounts?
- ACCOUNTADMIN
- ORGADMIN
- SECURITYADMIN
- SYSADMIN
Correct answer: A
Explanation:
The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake.This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake.This role has the highest level of privileges and is responsible for managing all aspects of the Snowflake account, including the ability to create and manage other user accounts1.
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Question 2
When unloading to a stage, which of the following is a recommended practice or approach?
- Set SINGLE: = true for larger files
- Use OBJECT_CONSTRUCT ( * ) when using Parquet
- Avoid the use of the CAST function
- Define an individual file format
Correct answer: D
Explanation:
When unloading data to a stage, it is recommended to define an individual file format.This ensures that the data is unloaded in a consistent and expected format, which can be crucial for downstream processing and analysis2 When unloading data to a stage, it is recommended to define an individual file format.This ensures that the data is unloaded in a consistent and expected format, which can be crucial for downstream processing and analysis2
Question 3
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
- 10-50 MB
- 100-250 MB
- 300-500 MB
- 1000-1500 MB
Correct answer: B
Explanation:
For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB.This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2. For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB.This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2.
Question 4
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
- External Tokenization
- External Tables
- Materialized Views
- User-Defined Table Functions (UDTF)
Correct answer: A
Explanation:
The feature in Snowflake that allows a user to substitute a randomly generated identifier for sensitive data before loading it into Snowflake is known as External Tokenization.This process helps to secure sensitive data by ensuring that it is not exposed in its original form, thus preventing unauthorized access3. The feature in Snowflake that allows a user to substitute a randomly generated identifier for sensitive data before loading it into Snowflake is known as External Tokenization.This process helps to secure sensitive data by ensuring that it is not exposed in its original form, thus preventing unauthorized access3.
Question 5
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
- VIEWS_HISTORY
- OBJECT_HISTORY
- ACCESS_HISTORY
- LOGIN_HISTORY
Correct answer: C
Explanation:
TheACCESS_HISTORYview in theSNOWFLAKE.ACCOUNT_USAGEschema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1. TheACCESS_HISTORYview in theSNOWFLAKE.ACCOUNT_USAGEschema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.
Question 6
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
- 1 second
- 60 seconds
- 5 minutes
- 60 minutes
Correct answer: B
Explanation:
When a running virtual warehouse in Snowflake is suspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2. When a running virtual warehouse in Snowflake is suspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.
Question 7
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
- Authentication
- Resource management
- Virtual warehouse caching
- Query parsing and optimization
- Query execution
- Physical storage of micro-partitions
Correct answer: ABD
Explanation:
The responsibilities of Snowflake's Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3. The responsibilities of Snowflake's Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3.
Question 8
How long is the Fail-safe period for temporary and transient tables?
- There is no Fail-safe period for these tables.
- 1 day
- 7 days
- 31 days
- 90 days
Correct answer: A
Explanation:
Temporary and transient tables in Snowflake do not have a Fail-safe period.Once the session ends or the tables are dropped, the data is purged and not recoverable1. Temporary and transient tables in Snowflake do not have a Fail-safe period.Once the session ends or the tables are dropped, the data is purged and not recoverable1.
Question 9
When is the result set cache no longer available? (Select TWO)
- When another warehouse is used to execute the query
- When another user executes the query
- When the underlying data has changed
- When the warehouse used to execute the query is suspended
- When it has been 24 hours since the last query
Correct answer: CE
Explanation:
The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data.Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1. The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data.Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.
Question 10
Which of the following describes external functions in Snowflake?
- They are a type of User-defined Function (UDF).
- They contain their own SQL code.
- They call code that is stored inside of Snowflake.
- They can return multiple rows for each row received
Correct answer: A
Explanation:
External functions in Snowflake are a special type of User-Defined Function (UDF) that call code executed outside of Snowflake, typically through a remote service.Unlike traditional UDFs, external functions do not contain SQL code within Snowflake; instead, they interact with external services to process data2.https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake. External functions in Snowflake are a special type of User-Defined Function (UDF) that call code executed outside of Snowflake, typically through a remote service.Unlike traditional UDFs, external functions do not contain SQL code within Snowflake; instead, they interact with external services to process data2.
https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20user%2Ddefined,code%20running%20outside%20of%20Snowflake.
