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? A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected B. 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. C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete. D. 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? A. list @file__stage B. show @file__stage C. view @file__stage D. verify @file__stage Answer: A Question: 85 Snowflake is designed for which type of workloads? (Choose two.) A. OLAP (Analytics) workloads B. OLTP (Transactional) workloads C. Concurrent workloads D. 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). A. Load files that are approximately 25 MB or smaller. B. Remove all dates and timestamps. C. Load files that are approximately 100-250 MB (or larger) D. Avoid using embedded characters such as commas for numeric data types E. 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. A. True B. 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) A. SCIM B. Federated authentication C. TLS 1.2 D. Key-pair authentication E. OAuth F. OCSP authentication Answer: B,D,E Question: 89 What is a machine learning and data science partner within the Snowflake Partner Ecosystem? A. Informatica B. Power Bl C. Adobe D. 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.) A. Customers can change the size of the Warehouse after creation B. A Warehouse can be resized while running C. A Warehouse can be configured to suspend after a period of inactivity D. 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? A. The primary cluster in the virtual warehouse B. The entire virtual warehouse C. The database in which the virtual warehouse resides D. 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.) A. Growth of storage and compute are tightly coupled together B. Storage expands without the requirement to add more compute C. Compute can be scaled up or down without the requirement to add more storage D. 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? A. The Snowflake Web Interface (UI) B. SQL commands C. Data integration tools D. 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. A. True B. 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? A. Standard B. Premier C. Enterprise D. 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? A. Data sharing within a specific region B. Query result retrieval C. Database replication D. 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. A. True B. 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.) A. Automatically creates a File Format object B. Automatically uses the last Stage created C. Automatically compresses files using Gzip D. 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? A. Micro-partitions B. Clustering keys C. Key partitions D. 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? A. LOAD B. copy C. GET D. 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