Question 1111 · 1323 in bank
What does the TableScan operator represent in the Query Profile?
Show answer
Answer: A
COF-C02AssociateSnowflakeAll questions freePage 112 of 133
COF-C02 practice questions 1,111–1,120
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
Official study references
1323 questions in this bank
Free access · progress saved on this device
Question 1112 · 1323 in bank
What information is found within the Statistic output in the Query Profile Overview?
Show answer
Answer: B
References
Question 1113 · 1323 in bank
When an object is created in Snowflake, who owns the object?
Show answer
Answer: C
Question 1114 · 1323 in bank
Select 2Which roles can make grant decisions to objects within a managed access schema? (Choose two.)
Show answer
Answer: AB
Explanation
A and B are correct: https://docs.snowflake.com/en/sql-reference/sql/grant-privilege Only the SECURITYADMIN and ACCOUNTADMIN system roles have the MANAGE GRANTS privilege; however, the privilege can be granted to custom roles. https://docs.snowflake.com/en/user-guide/security-access-control-configure With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management. Since SECURITYADMIN and ACCOUNTADMIN have the MANAGE GRANTS global privilege, they can grant privileges on objects in a managed access schema.
Source: Adapted from community discussion — ahadh7621
Question 1115 · 1323 in bank
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
Show answer
Answer: A
Explanation
To post-process the output of File Format command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.
Source: Adapted from community discussion — nexerSnow
Question 1116 · 1323 in bank
A Snowflake account administrator has set the resource monitors as shown in the diagram, with actions defined for each resource monitor as “Notify & Suspend Immediately”.
What is the MAXIMUM limit of credits that Warehouse 2 can consume?
Show answer
Answer: D
Explanation
Warehouse 2 is controlled by policy on the account level and all five warehouses usage count toward this limit. Having limit on another warehouses (in this example: 3, 4, 5) just means that warehouse 3, 4, 5 can be suspended earlier when reaching their limits. The question ask for the MAXIMUM, so the best case scenario for warehouse 2 is that other warehouses doesn't consume ANY resources and in such case warehouse 2 can burn whole 5000 limit. Eventually: answer D
Source: Adapted from community discussion — Isio05
References
Question 1117 · 1323 in bank
True or False: You can query the files in an External Stage directly without having to load the data into a table.
Show answer
Answer: A
Explanation
False: You cannot directly query the files in an External Stage without having to load the data into a table in Snowflake. Here's why: External stages act as pointers to data residing in external cloud storage locations like S3 or Azure Blob Storage. Snowflake doesn't have direct access to the data format or schema within those files. To query the data, you need to first load it into a Snowflake table using the COPY INTO command. This process reads the data from the external stage, parses it based on the specified format definition, and populates the target table within Snowflake. Once the data is loaded into a Snowflake table, you can then use standard SQL queries to access and analyze it. In essence, external stages serve as a staging area for data before it's brought into Snowflake for processing and querying.
Source: Adapted from community discussion — Alex_Ovidiu
References
Question 1118 · 1323 in bank
Select 2When initially creating an account in Snowflake, which settings can be specified? (Choose two.)
Show answer
Answer: DE
Explanation
ADE are correct create account myaccount1 admin_name = admin admin_password = 'TestPassword1' first_name = Jane last_name = Smith email = 'myemail@myorg.org' edition = enterprise region = aws_us_west_2;
Source: Adapted from community discussion — kayuhanbiduk
References
Question 1119 · 1323 in bank
What is one of the benefits of using a multi-cluster virtual warehouse?
Show answer
Answer: D
References
Question 1120 · 1323 in bank
When should a multi-cluster virtual warehouse be used in Snowflake?
Show answer
Answer: A
References
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1111. 1323 questions available.
About this question bank
Version 1.0.0. How we source questions