Ask Question
Snowflake COF-R02 Practice Test - Questions Answers, Page 6
List of questions
Question 51
What privileges are required to create a task?
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks
Question 52
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
Question 53
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Question 54
True or False: You can query the files in an External Stage directly without having to load the data into a table.
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.
Question 55
True or False: An active warehouse is required to run a COPY INTO statement.
Question 56
True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.
Reference: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html
Question 57
True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
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.
Question 58
Which of the following statements is true of Snowflake?
Reference: https://www.stitchdata.com/resources/snowflake/
Question 59
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question 60
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html
Related questions
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question