Ask Question
Snowflake COF-R02 Practice Test - Questions Answers, Page 3
Add to Whishlist
List of questions
Question 21
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Reference: https://docs.snowflake.com/en/user-guide-data-unload.html
Question 22
Select the different types of Internal Stages: (Choose three.)
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage
Question 23
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflakecredits are charged based on the number of virtual warehouses you use, how long they run, and theirsize."
Question 24
True or False: The COPY command must specify a File Format in order to execute.
Create Stage:
https://docs.snowflake.com/en/sql-reference/sql/create-stage.html
Create Table (STAGE_FILE_FORMAT option):
https://docs.snowflake.com/en/sql-reference/sql/create-table.html
Copy Into:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
Question 25
Which of the following objects can be cloned? (Choose four.)
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks
Question 26
Snowflake is designed for which type of workloads? (Choose two.)
Reference: https://blog.couchbase.com/its-the-workload-stupid/
https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-forwarehousing
Question 27
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
Question 28
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/
Question 29
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html
Question 30
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)
Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-datawarehousedoesntseparate-storage-and-compute-65d2dffd450f
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