COF-R02 Demo and Sample
Note: Answers are below each question.
Samples are taken from full version.
Latest COF-R02 Exam Questions and Practice Tests 2024 - Killexams.com
COF-R02 Dumps COF-R02 Braindumps
COF-R02 Real Questions COF-R02 Practice Test COF-R02 Actual Questions
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
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?
list @file stage
show @file stage
view @file stage
verify @file stage
Answer: A
Question: 85
Snowflake is designed for which type of workloads? (Choose two.)
OLAP (Analytics) workloads
OLTP (Transactional) workloads
Concurrent workloads
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).
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
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.
True
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)
SCIM
Federated authentication
TLS 1.2
Key-pair authentication
OAuth
OCSP authentication
Answer: B,D,E
Question: 89
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Informatica
Power Bl
Adobe
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.)
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
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?
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
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.)
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
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?
The Snowflake Web Interface (UI)
SQL commands
Data integration tools
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.
True
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?
Standard
Premier
Enterprise
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?
Data sharing within a specific region
Query result retrieval
Database replication
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.
True
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.)
Automatically creates a File Format object
Automatically uses the last Stage created
Automatically compresses files using Gzip
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?
Micro-partitions
Clustering keys
Key partitions
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?
LOAD
copy
GET
PUT
Answer: D Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9
6$03/( 48(67,216
7KHVH TXHVWLRQV DUH IRU GHPR SXUSRVH RQO\ )XOO YHUVLRQ LV XS WR GDWH DQG FRQWDLQV DFWXDO TXHVWLRQV DQG DQVZHUV
.LOOH[DPV FRP LV DQ RQOLQH SODWIRUP WKDW RIIHUV D ZLGH UDQJH RI VHUYLFHV UHODWHG WR FHUWLILFDWLRQ H[DP SUHSDUDWLRQ 7KH SODWIRUP SURYLGHV DFWXDO TXHVWLRQV H[DP GXPSV DQG SUDFWLFH WHVWV WR KHOS LQGLYLGXDOV SUHSDUH IRU YDULRXV FHUWLILFDWLRQ H[DPV ZLWK FRQILGHQFH +HUH DUH VRPH NH\ IHDWXUHV DQG VHUYLFHV RIIHUHG E\ .LOOH[DPV FRP
$FWXDO ([DP 4XHVWLRQV .LOOH[DPV FRP SURYLGHV DFWXDO H[DP TXHVWLRQV WKDW DUH H[SHULHQFHG LQ WHVW FHQWHUV 7KHVH TXHVWLRQV DUH XSGDWHG UHJXODUO\ WR HQVXUH WKH\ DUH XS WR GDWH DQG UHOHYDQW WR WKH ODWHVW H[DP V\OODEXV %\ VWXG\LQJ WKHVH DFWXDO TXHVWLRQV FDQGLGDWHV FDQ IDPLOLDUL]H WKHPVHOYHV ZLWK WKH FRQWHQW DQG IRUPDW RI WKH UHDO H[DP
([DP 'XPSV .LOOH[DPV FRP RIIHUV H[DP GXPSV LQ 3') IRUPDW 7KHVH GXPSV FRQWDLQ D FRPSUHKHQVLYH FROOHFWLRQ RI TXHVWLRQV DQG DQVZHUV WKDW FRYHU WKH H[DP WRSLFV %\ XVLQJ WKHVH GXPSV FDQGLGDWHV FDQ HQKDQFH WKHLU NQRZOHGJH DQG LPSURYH WKHLU FKDQFHV RI VXFFHVV LQ WKH FHUWLILFDWLRQ H[DP
3UDFWLFH 7HVWV .LOOH[DPV FRP SURYLGHV SUDFWLFH WHVWV WKURXJK WKHLU GHVNWRS 9&( H[DP VLPXODWRU DQG RQOLQH WHVW HQJLQH 7KHVH SUDFWLFH WHVWV VLPXODWH WKH UHDO H[DP HQYLURQPHQW DQG KHOS FDQGLGDWHV DVVHVV WKHLU UHDGLQHVV IRU WKH DFWXDO H[DP 7KH SUDFWLFH WHVWV FRYHU D ZLGH UDQJH RI TXHVWLRQV DQG HQDEOH FDQGLGDWHV WR LGHQWLI\ WKHLU VWUHQJWKV DQG ZHDNQHVVHV
*XDUDQWHHG 6XFFHVV .LOOH[DPV FRP RIIHUV D VXFFHVV JXDUDQWHH ZLWK WKHLU H[DP GXPSV 7KH\ FODLP WKDW E\ XVLQJ WKHLU PDWHULDOV FDQGLGDWHV ZLOO SDVV WKHLU H[DPV RQ WKH ILUVW DWWHPSW RU WKH\ ZLOO UHIXQG WKH SXUFKDVH SULFH 7KLV JXDUDQWHH SURYLGHV DVVXUDQFH DQG FRQILGHQFH WR LQGLYLGXDOV SUHSDULQJ IRU FHUWLILFDWLRQ H[DPV
8SGDWHG &RQWHQW .LOOH[DPV FRP UHJXODUO\ XSGDWHV LWV TXHVWLRQ EDQN DQG H[DP GXPSV WR HQVXUH WKDW WKH\ DUH FXUUHQW DQG UHIOHFW WKH ODWHVW FKDQJHV LQ WKH H[DP V\OODEXV 7KLV KHOSV FDQGLGDWHV VWD\ XS WR GDWH ZLWK WKH H[DP FRQWHQW DQG LQFUHDVHV WKHLU FKDQFHV RI VXFFHVV
7HFKQLFDO 6XSSRUW .LOOH[DPV FRP SURYLGHV IUHH [ WHFKQLFDO VXSSRUW WR DVVLVW FDQGLGDWHV ZLWK DQ\ TXHULHV RU LVVXHV WKH\ PD\ HQFRXQWHU ZKLOH XVLQJ WKHLU VHUYLFHV 7KHLU FHUWLILHG H[SHUWV DUH DYDLODEOH WR SURYLGH JXLGDQFH DQG KHOS FDQGLGDWHV WKURXJKRXW WKHLU H[DP SUHSDUDWLRQ MRXUQH\
'PS .PSF FYBNT WJTJU IUUQT LJMMFYBNT DPN WFOEPST FYBN MJTU
.LOO \RXU H[DP DW )LUVW $WWHPSW *XDUDQWHHG
View Practice Questions »