COF-R02 MCQs
COF-R02 TestPrep COF-R02 Study Guide COF-R02 Practice Test
COF-R02 Exam Questions
killexams.com SnowFlake COF-R02
Snowflake SnowPro Core Recertification
https://killexams.com/pass4sure/exam-detail/COF-R02
Question: 83
What happens when a virtual warehouse is resized?
When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
Users who are trying to use the warehouse will receive an error message until the resizing is complete
Question: 84
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
list @file stage
show @file stage
view @file stage
verify @file stage
Question: 85
Snowflake is designed for which type of workloads? (Choose two.)
OLAP (Analytics) workloads
OLTP (Transactional) workloads
Concurrent workloads
On-premise workloads
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-for-warehousing
Question: 86
Which of the following are best practice recommendations that should be considered when loading data into
Snowflake? (Select TWO).
Load files that are approximately 25 MB or smaller.
Remove all dates and timestamps.
Load files that are approximately 100-250 MB (or larger)
Avoid using embedded characters such as commas for numeric data types
Remove semi-structured data types
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
Question: 87
True or False: A Snowflake account is charged for data stored in both Internal and External Stages.
True
False
Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html
Question: 88
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
SCIM
Federated authentication
TLS 1.2
Key-pair authentication
OAuth
OCSP authentication
Question: 89
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Informatica
Power Bl
Adobe
Data Robot
Explanation:
https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html
Question: 90
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
Customers can change the size of the Warehouse after creation
A Warehouse can be resized while running
A Warehouse can be configured to suspend after a period of inactivity
A Warehouse can be configured to auto-resume when new queries are submitted
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Question: 91
A virtual warehouse???s auto-suspend and auto-resume settings apply to which of the following?
The primary cluster in the virtual warehouse
The entire virtual warehouse
The database in which the virtual warehouse resides
The Queries currently being run on the virtual warehouse
https://docs.snowflake.com/en/user-guide/warehouses- overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.
Question: 92
Which of the following statements describes a benefit of Snowflake???s separation of compute and storage? (Choose all that apply.)
Growth of storage and compute are tightly coupled together
Storage expands without the requirement to add more compute
Compute can be scaled up or down without the requirement to add more storage
Multiple compute clusters can access stored data without contention
Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt- separate-storage-and-compute-65d2dffd450f
Question: 93
Which interfaces can be used to create and/or manage Virtual Warehouses?
The Snowflake Web Interface (UI)
SQL commands
Data integration tools
All of the above
Reference: https://docs.snowflake.com/en/user-guide/warehouses.html
Question: 94
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
True
False
Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.
Question: 95
What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?
Standard
Premier
Enterprise
Business Critical Edition
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question: 96
In which use cases does Snowflake apply egress charges?
Data sharing within a specific region
Query result retrieval
Database replication
Loading data into Snowflake
Cloud providers apply data egress charges in either of the following use cases: Data is transferred from one region to another within the same cloud platform. Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data- transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the% 20cloud%20platform.
Question: 97
True or False: It is possible to load data into Snowflake without creating a named File Format object.
True
False
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
Question: 98
The PUT command: (Choose two.)
Automatically creates a File Format object
Automatically uses the last Stage created
Automatically compresses files using Gzip
Automatically encrypts files
Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
Question: 99
What feature can be used to reorganize a very large table on one or more columns?
Micro-partitions
Clustering keys
Key partitions
Clustered partitions
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Question: 100
Which command can be used to load data into an internal stage?
LOAD
copy
GET
PUT
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9
KILLEXAMS.COM
Killexams.com is a leading online platform specializing in high-quality certification exam preparation. Offering a robust suite of tools, including MCQs, practice tests, and advanced test engines, Killexams.com empowers candidates to excel in their certification exams. Discover the key features that make Killexams.com the go-to choice for exam success.
Killexams.com provides exam questions that are experienced in test centers. These questions are updated regularly to ensure they are up-to-date and relevant to the latest exam syllabus. By studying these questions, candidates can familiarize themselves with the content and format of the real exam.
Killexams.com offers exam MCQs in PDF format. These questions contain a comprehensive
collection of questions and answers that cover the exam topics. By using these MCQs, candidate can enhance their knowledge and improve their chances of success in the certification exam.
Killexams.com provides practice test through their desktop test engine and online test engine. These practice tests simulate the real exam environment and help candidates assess their readiness for the actual exam. The practice test cover a wide range of questions and enable candidates to identify their strengths and weaknesses.
Killexams.com offers a success guarantee with the exam MCQs. Killexams claim that by using this materials, candidates will pass their exams on the first attempt or they will get refund for the purchase price. This guarantee provides assurance and confidence to individuals preparing for certification exam.
Killexams.com regularly updates its question bank of MCQs to ensure that they are current and reflect the latest changes in the exam syllabus. This helps candidates stay up-to-date with the exam content and increases their chances of success.