Give Push to your Success with SnowPro Core COF-C03 Exam Questions
COF-C03 100% Guarantee Download COF-C03 Exam PDF Q&A
NEW QUESTION # 642
What is the MAXIMUM Time Travel retention period for a transient table?
- A. O days
- B. 7 days
- C. 1 day
- D. 90 days
Answer: C
Explanation:
The maximum Time Travel retention period for a transient table in Snowflake is 1 day.This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.
NEW QUESTION # 643
How long does Snowflake retain information in the ACCESS HISTORY view?
- A. 365 days
- B. 14 days
- C. 7 days
- D. 28 days
Answer: A
Explanation:
Snowflake retains information in the ACCESS HISTORY view for 365 days.This allows users to query the access history of Snowflake objects within the last year1.
NEW QUESTION # 644
Which roles are needed to access Document AI? Select TWO.
- A. PUBLIC
- B. SYSADMIN
- C. ACCOUNTADMIN
- D. OBJECT_VIEWER
- E. DOCUMENT_INTELLIGENCE_CREATOR
Answer: C,E
Explanation:
The correct answers are C. ACCOUNTADMIN and E. DOCUMENT_INTELLIGENCE_CREATOR .
Document AI is part of Snowflake Cortex and uses specific privileges/roles for access and administration. The ACCOUNTADMIN role is commonly required for initial setup or granting required privileges, while DOCUMENT_INTELLIGENCE_CREATOR is used to create and work with Document AI objects.
Why C is correct:
ACCOUNTADMIN has the account-level authority needed to enable or manage required access for Document AI features.
Why E is correct:
DOCUMENT_INTELLIGENCE_CREATOR is the Snowflake role associated with creating Document AI- related objects and using Document AI capabilities.
Why the other options are incorrect:
A). PUBLIC is available to all users but does not provide Document AI creation privileges.
B). SYSADMIN manages many account objects, but it is not the specific Document AI role in the answer set.
D). OBJECT_VIEWER is a Snowflake database role for object metadata visibility, not Document AI access.
Official Snowflake documentation reference:
Snowflake documentation for Document AI describes the required access model and includes the DOCUMENT_INTELLIGENCE_CREATOR role for creating Document AI objects, with account administrator involvement for setup.
Reference: Snowflake Documentation - Document AI; Snowflake Cortex; SnowPro Core Study Guide - Snowflake Architecture and Security.
==
NEW QUESTION # 645
A developer is granted ownership of a table that has a masking policy. The developer ' s role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
- A. No, because masking policies must always reference specific access roles.
- B. No, because ownership of a table does not include the ability to change masking policies
- C. Yes, because a table owner has full control and can unset masking policies.
- D. Yes, because masking policies only apply to cloned tables.
Answer: B
Explanation:
Even if a developer is granted ownership of a table with a masking policy, they will not be able to modify the table to read the masked data if their role does not have the necessary permissions. Ownership of a table does not automatically confer the ability to alter masking policies, which are designed to protect sensitive data. Masking policies are applied at the schema level and requirespecific privileges to modify12.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Masking Policies
NEW QUESTION # 646
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
- A. LIMIT
- B. GROUP BY
- C. PARTITION BY
- D. UNION ALL
- E. ORDER BY
Answer: C,E
Explanation:
Valid sub-clauses to theOVERclause for a window function in SQL are:
C). ORDER BY: This clause specifies the order in which the rows in a partition are processed by the window function. It is essential for functions that depend on the row order, such as ranking functions.
D). PARTITION BY: This clause divides the result set into partitions to which the window function is applied.
Each partition is processed independently of other partitions, making it crucial for functions that compute values across sets of rows that share common characteristics.
These clauses are fundamental to defining the scope and order of data over which the window function operates, enabling complex analytical computations within SQL queries.
References:
Snowflake Documentation: Window Functions
NEW QUESTION # 647
Which privilege is required to access a virtual warehouse load chart?
- A. MONITOR
- B. OPERATE
- C. READ
- D. USAGE
Answer: B
NEW QUESTION # 648
Which tool or service can be used to graphically explore and manage data stored within a Snowflake account, including databases, tables, and views?
- A. Snowsight
- B. Snowflake virtual warehouses
- C. SnowCD
- D. SnowSQL
Answer: A
NEW QUESTION # 649
Which command will unload data from a table into an external stage?
- A. COPY INTO < location >
- B. PUT
- C. INSERT
- D. GET
Answer: A
Explanation:
In Snowflake, theCOPY INTO < location > command is used to unload (export) data from a Snowflake table to an external stage, such as an S3 bucket, Azure Blob Storage, or Google Cloud Storage. This command allows users to specify the format, file size, and other options for the data being unloaded, making it a flexible solution for exporting data from Snowflake to external storage solutions for further use or analysis.
References: Snowflake Documentation on Data Unloading
NEW QUESTION # 650
When cloning a database, what is cloned with the database? (Choose two.)
- A. Only schemas and tables within the database
- B. Future child objects within the database
- C. Existing child objects within the database
- D. Privileges on the schemas within the database
- E. Privileges on the database
Answer: C,E
Explanation:
When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc. However, it does not include future child objects or privileges on schemas within the database2.
References = [ COF-C03 ] SnowPro Core Certification Exam Study Guide, Snowflake Documentation
NEW QUESTION # 651
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
- A. Data storage
- B. Metadata
- C. Authentication
- D. Query execution
- E. Compute resources
Answer: B,C
Explanation:
The Snowflake Cloud Services layer manages various services, including authentication and metadata management.This layer ties together all the different components of Snowflake to process user requests, manage sessions, and control access3.
NEW QUESTION # 652
Which Snowflake security feature has the HIGHEST precedence in the security feature hierarchy?
- A. Account roles
- B. Snowflake OAuth
- C. Network policies
- D. Masking policies
Answer: A
NEW QUESTION # 653
What is the EXPLAIN function used for in Snowflake?
- A. To execute a SQL statement and provide a history of the query execution, including the number of cloud services credits consumed
- B. To compile a SQL statement and provide an execution plan while consuming cloud service credits
- C. To compile a SQL statement and provide an execution plan using a virtual warehouse
- D. To execute a SQL statement and provide a history of the query execution and the number of compute credits consumed
Answer: B
Explanation:
The correct answer is B. To compile a SQL statement and provide an execution plan while consuming cloud service credits .
The EXPLAIN command returns the logical execution plan for a SQL statement. It compiles the SQL statement but does not execute it. Because the statement is compiled and optimized by Snowflake's cloud services layer, it does not require a running virtual warehouse.
Why B is correct:
EXPLAIN generates an execution plan without running the query. The compile and optimization work happens in the cloud services layer. Cloud services usage may apply according to Snowflake's normal cloud services credit rules.
Why the other options are incorrect:
A). EXPLAIN does not require a virtual warehouse to execute the query because the query is not actually run.
C). EXPLAIN does not execute the SQL statement and does not provide actual query history or compute credit consumption.
D). EXPLAIN does not execute the statement or return execution history.
Official Snowflake documentation reference:
Snowflake documentation describes EXPLAIN as a command that returns the logical execution plan for a SQL statement without executing the statement. Snowflake's cloud services layer handles query parsing and optimization.
Reference: Snowflake Documentation - EXPLAIN; Snowflake Documentation - Snowflake architecture cloud services layer; SnowPro Core Study Guide - Performance Optimization.
==
NEW QUESTION # 654
What are the main differences between the account usage views and the information schema views? (Select TWO).
- A. No active warehouse to needed to query account usage views but one is needed to query information schema views.
- B. Account issue views contain dropped objects but information schema views do not.
- C. Information schema views are read-only but account usage views are not.
- D. Account usage views do not contain data about tables but information schema views do.
- E. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
Answer: B,E
Explanation:
The account usage views in Snowflake provide historical usage data about the Snowflake account, and they retain this data for a period of up to 1 year. These views include information about dropped objects, enabling audit and tracking activities. On the other hand, information schema views provide metadata about database objects currently in use, such as tables and views, but do not include dropped objects. The retention of data in information schema views varies, but it is generally shorter than the retention for account usage views, ranging from 7 days to a maximum of 6 months, depending on the specific view.
References: Snowflake Documentation on Account Usage and Information Schema
NEW QUESTION # 655
What happens when a value in a single row of a large table is updated?
- A. The affected micro-partition will be deleted and recreated.
- B. The affected micro-partition will be modified.
- C. All existing micro-partitions will be modified.
- D. All micro-partitions will be deleted and recreated.
Answer: A
NEW QUESTION # 656
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Tables
- B. Secure User Defined Functions (UDFs)
- C. Materialized views
- D. Procedures
- E. Sequences
Answer: A,B
Explanation:
Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically copying the data, thus not consuming additional storage. Tables and Secure User Defined Functions (UDFs) are among the objects that can be shared using this feature. Materialized views, sequences, and procedures are not shareable objects in Snowflake.
References:
[ COF-C03 ] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Secure Data Sharing1
NEW QUESTION # 657
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
- A. DATA_RETENTION_TIME_IN_DAYS
- B. MAX_DATA_EXTENSION_TIME_IN_DAYS
- C. MIN_DATA_RETENTION_TIME_IN_DAYS
- D. MAX CONCURRENCY LEVEL
Answer: A
Explanation:
The parameter DATA_RETENTION_TIME_IN_DAYS can be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.
NEW QUESTION # 658
Which command will create an ARRAY output from inputs ' a ' and ' b ' ?
- A. AS_ARRAY( ' a ' , ' b ' );
- B. TO_ARRAY( ' a ' , ' b ' );
- C. ARRAY_CONSTRUCT( ' a ' , ' b ' );
- D. LISTAGG( ' a ' , ' b ' );
Answer: D
NEW QUESTION # 659
How often are encryption keys automatically rotated by Snowflake?
- A. 60 Days
- B. 90 Days
- C. 30 Days
- D. 365 Days
Answer: C
Explanation:
Snowflake automatically rotates encryption keys when they are more than 30 days old. Active keys are retired, and new keys are created. This process is part of Snowflake's comprehensive security measures to ensure data protection and is managed entirely by the Snowflake service without requiring user intervention.
References:
Understanding Encryption Key Management in Snowflake
NEW QUESTION # 660
Which steps will help optimize query performance? (Select TWO).
- A. Indexing a column
- B. Increasing the size of the micro-partitions
- C. Using the query acceleration service
- D. Decreasing the size of the virtual warehouse
- E. Clustering a table
Answer: B,D
NEW QUESTION # 661
......
Get COF-C03 Actual Free Exam Q&As to Prepare Certification: https://www.practicematerial.com/COF-C03-exam-materials.html
Snowflake Actual Free Exam Questions And Answers: https://drive.google.com/open?id=1Ea3mdAuqYjm0kHPU5-AOtHyMBqDD2bGL
