Ask Question
Snowflake COF-R02 Practice Test - Questions Answers, Page 5
Add to Whishlist
List of questions
Question 41
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 42
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html
Question 43
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html
Question 44
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html
Question 45
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse
Question 46
Which of the following terms best describes Snowflake’s database architecture?
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.
Question 47
Which of the following objects is not covered by Time Travel?
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html
Question 48
When can a Virtual Warehouse start running queries?
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 49
True or False: Pipes can be suspended and resumed.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
Question 50
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.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
$
3
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
20
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