COF-R02 : Snowflake SnowPro Core Recertification Exam

COF-R02 Dumps COF-R02 Braindumps
COF-R02 Real Questions COF-R02 Practice Test COF-R02 Actual 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?
1. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
2. 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.
3. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
4. Users who are trying to use the warehouse will receive an error message until the resizing is complete
Answer: B
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?
1. list @file stage
2. show @file stage
3. view @file stage
4. verify @file stage
Answer: A
Question: 85
Snowflake is designed for which type of workloads? (Choose two.)
1. OLAP (Analytics) workloads
2. OLTP (Transactional) workloads
3. Concurrent workloads
4. On-premise workloads
Answer: A,C Explanation: 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-for-warehousing
Question: 86
Which of the following are best practice recommendations that should be considered when loading data into
Snowflake? (Select TWO).
1. Load files that are approximately 25 MB or smaller.
2. Remove all dates and timestamps.
3. Load files that are approximately 100-250 MB (or larger)
4. Avoid using embedded characters such as commas for numeric data types
5. Remove semi-structured data types
Answer: C,D Explanation:
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.
1. True
2. False
Answer: A Explanation:
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)
1. SCIM
2. Federated authentication
3. TLS 1.2
4. Key-pair authentication
5. OAuth
6. OCSP authentication
Answer: B,D,E
Question: 89
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
1. Informatica
2. Power Bl
3. Adobe
4. Data Robot
Answer: D
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.)
1. Customers can change the size of the Warehouse after creation
2. A Warehouse can be resized while running
3. A Warehouse can be configured to suspend after a period of inactivity
4. A Warehouse can be configured to auto-resume when new queries are submitted
Answer: A,B,C,D Explanation:
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?
1. The primary cluster in the virtual warehouse
2. The entire virtual warehouse
3. The database in which the virtual warehouse resides
4. The Queries currently being run on the virtual warehouse
Answer: B Explanation:
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.)
1. Growth of storage and compute are tightly coupled together
2. Storage expands without the requirement to add more compute
3. Compute can be scaled up or down without the requirement to add more storage
4. Multiple compute clusters can access stored data without contention
Answer: B,C,D Explanation:
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?
1. The Snowflake Web Interface (UI)
2. SQL commands
3. Data integration tools
4. All of the above
Answer: D Explanation:
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.
1. True
2. False
Answer: A Explanation:
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?
1. Standard
2. Premier
3. Enterprise
4. Business Critical Edition
Answer: C Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question: 96
In which use cases does Snowflake apply egress charges?
1. Data sharing within a specific region
2. Query result retrieval
3. Database replication
4. Loading data into Snowflake
Answer: A Explanation:
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.
1. True
2. False
Answer: A Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
Question: 98
The PUT command: (Choose two.)
1. Automatically creates a File Format object
2. Automatically uses the last Stage created
3. Automatically compresses files using Gzip
4. Automatically encrypts files
Answer: C,D Explanation:
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?
1. Micro-partitions
2. Clustering keys
3. Key partitions
4. Clustered partitions
Answer: B Explanation:
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?
1. LOAD
2. copy
3. GET
4. PUT
Answer: D Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

User: Mickey***** Exceptional question bank made passing my cof-r02 exams seamless, and I congratulate their team on their well-executed resources. Their testprep materials provided comprehensive preparation, ensuring I was ready for every question, and I highly recommend their services.

User: Alma***** If you are looking for high-quality COF-R02 practice tests, Killexams.com is the ultimate choice. I was proven wrong about the usefulness of COF-R02 practice tests because Killexams.com provided me with excellent practice tests that helped me score high on the exam. If you are also worried about COF-R02 practice tests, you can trust Killexams.com.

User: Agnes***** The cof-r02 exam preparation with Killexams.com was the best I have ever experienced. Their Questions and Answers covered everything I needed, and the full-sized practice tests were incredibly helpful. The money-back guarantee is also trustworthy. I will definitely recommend this to others.

User: Tassiana***** The accurate questions and answers provided by Killexams.com helped me pass COF-R02 on my first try with 78% marks. My actual score was closer to 90%, but due to some minor issues with marking, it settled at 78%. I truly appreciate the excellent job done by the Killexams.com team and wish them all the success.

User: Ansh***** Achieving a 93% score on the cof-r02 exam was a dream come true, made possible by Killexams.com’s concise and accurate Questions and Answers. Despite limited preparation time, their clear materials ensured I was well-equipped to succeed.

---