Pass COF-C02 Exam - Real Test Engine PDF with 503 Questions
Get New COF-C02 Certification Practice Test Questions Exam Dumps
The Snowflake COF-C02 exam is designed for individuals who have experience using Snowflake to build, manage, and maintain data warehouses and databases. COF-C02 exam consists of 90 multiple-choice questions, and you will have 2 hours to complete the exam. The questions are designed to test your knowledge of Snowflake’s architecture, data loading and unloading, SQL, data modeling, security, and performance tuning.
NEW QUESTION # 48
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?
- A. Snowflake will only check the schema the UDF belongs to.
- B. Snowflake will first check the current schema, and then the schema the previous query used
- C. Snowflake will resolve them according to the SEARCH_PATH parameter.
- D. Snowflake will first check the current schema, and them the PUBLIC schema of the current database.
Answer: D
NEW QUESTION # 49
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
- A. Customer managed keys (Tri-secret secure)
- B. Database replication and failover
- C. Extended time travel
- D. Automated index management
- E. Native support for geospatial data
Answer: B,C
NEW QUESTION # 50
What is the minimum Snowflake edition required for row level security?
- A. Virtual Private Snowflake
- B. Business Critical
- C. Enterprise
- D. Standard
Answer: C
NEW QUESTION # 51
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. XML
- B. CSV
- C. ORC
- D. JSON
- E. Parquet
- F. AVRO
Answer: B,D,E
NEW QUESTION # 52
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. True
- B. False
Answer: A
NEW QUESTION # 53
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A. Enclose fields that contain delimiter characters in single or double quotes.
- B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
- C. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
- D. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
- E. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- F. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
Answer: A,B,F
NEW QUESTION # 54
True or False: Pipes can be suspended and resumed.
- A. True
- B. False
Answer: A
NEW QUESTION # 55
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
- A. flatten
- B. parse_json()
- C. object_construct()
- D. json_extract_path_text()
Answer: D
NEW QUESTION # 56
How long is the Fail-safe period for temporary and transient tables?
- A. 7 days
- B. 90 days
- C. 31 days
- D. 1 day
- E. There is no Fail-safe period for these tables.
Answer: E
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html
NEW QUESTION # 57
Where is Snowflake metadata stored?
- A. In the cloud services layer
- B. Within the data files
- C. In the virtual warehouse layer
- D. In the remote storage layer
Answer: C
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/querying-metadata.html#:~:text=Snowflake%20automatically%20gen
NEW QUESTION # 58
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
- A. Federated authentication
- B. SCIM
- C. OAuth
- D. TLS 1.2
- E. Key-pair authentication
- F. OCSP authentication
Answer: A,C,E
NEW QUESTION # 59
Which activities are included in the Cloud Services layer? {Select TWO).
- A. Partition scanning
- B. Dynamic data masking
- C. Data storage
- D. User authentication
- E. Infrastructure management
Answer: D,E
NEW QUESTION # 60
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
- A. Submit listings for approval/publishing.
- B. Modify listings properties.
- C. Modify incoming listing access requests.
- D. Delete provider profiles.
- E. Rename listings.
Answer: A,B
NEW QUESTION # 61
Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?
- A. QUERY_HISTORY
- B. COPY_HISTORY
- C. ACCESS_HISTORY
- D. LOAD_HOSTORY
Answer: C
NEW QUESTION # 62
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. All of the above
- B. Data integration tools
- C. The Snowflake Web Interface (UI)
- D. SQL commands
Answer: A
NEW QUESTION # 63
Select the three types of tables that exist within Snowflake. Choose 3 answers
- A. Provisioned
- B. Permanent
- C. Transient
- D. Temporary
Answer: B,C,D
NEW QUESTION # 64
How does Snowflake describe its unique architecture?
- A. A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)
- B. A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)
- C. A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)
- D. A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)
Answer: D
NEW QUESTION # 65
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
- A. 4 hours
- B. 1 hour
- C. 8 hours
- D. 2 hours
Answer: A
NEW QUESTION # 66
What are the main differences between the account usage views and the information schema views? (Select TWO).
- A. Account issue views contain dropped objects but information schema views do not.
- B. No active warehouse to needed to query account usage views but one is needed to query information schema views.
- C. Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.
- D. Information schema views are read-only but account usage views are not.
- E. Account usage views do not contain data about tables but information schema views do.
Answer: A,C
NEW QUESTION # 67
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
- A. INSERT INTO
- B. COPY INTO
- C. CREATE PIPE
- D. TABLE STREAM
Answer: C
NEW QUESTION # 68
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Tables
- B. Materialized views
- C. Sequences
- D. Secure User Defined Functions (UDFs)
- E. Procedures
Answer: A,D
Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html
NEW QUESTION # 69
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
- A. Concurrency
- B. Performance
Answer: B
NEW QUESTION # 70
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. Multiple compute clusters can access stored data without contention
- C. Storage expands without the requirement to add more compute
- D. Growth of storage and compute are tightly coupled together
Answer: A,B,C
NEW QUESTION # 71
......
Snowflake COF-C02 (SnowPro Core Certification) Certification Exam is an excellent way for Snowflake users to validate their expertise and demonstrate their proficiency with the Snowflake cloud platform. SnowPro Core Certification Exam certification is well-respected and widely acknowledged in the data management and analytics industry, and it is a great way to boost your career prospects.
COF-C02 Exam Dumps - PDF Questions and Testing Engine: https://www.fast2test.com/COF-C02-premium-file.html
Real COF-C02 Exam Dumps Questions Valid COF-C02 Dumps PDF: https://drive.google.com/open?id=1U5lVkb0YAafRQn8t0xN6taCNXgJe9wSF