Snowflake COF-C02 SnowPro Core Certification https://killexams.com/pass4sure/exam-detail/COF-C02 Question: 64 What happens when a Data Provider revokes privileges to a Share on an object in their source database? A. The object immediately becomes unavailable for all Data Consumers B. Any additional data arriving after this point in time will not be visible to Data Consumers C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers’ accounts Answer: A Question: 65 Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred? A. 1 Hour B. 3 Hours C. 12 hours D. 24 hours Answer: D Explanation: Reference: https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse Question: 66 Which of the following statements would be used to export/unload data from Snowflake? A. COPY INTO @stage B. EXPORT TO @stage C. INSERT INTO @stage D. EXPORT_TO_STAGE (stage = > @Wage, select = > ‘select * from t1); Answer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html Question: 67 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: 68 True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started. A. True B. False Answer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/credits.html Question: 69 Which are true of Snowflake roles? A. All grants to objects are given to roles, and never to users B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation C. The public role controls at other roles D. Roles are a subset of users and users own objects In Snowflake Answer: A,B Question: 70 Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers A. SnowSQL B. ODBC C. R D. HIVE Answer: A,B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html Question: 71 Which data types does Snowflake support when querying semi-structured data? (Select TWO) A. VARIANT B. ARRAY C. VARCHAR D. XML E. BLOB Answer: A,B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB. A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array. Question: 72 Which copy INTO command outputs the data into one file? A. SINGLE=TRUE B. MAX_FILE_NUMBER=1 C. FILE_NUMBER=1 D. MULTIPLE=FAISE Answer: B Question: 73 True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake. A. True B. False Answer: A Question: 74 The FLATEEN function is used to query which type of data in Snowflake? A. Structured data B. Semi-structured data C. Both of the above D. None of the above Answer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/querying-semistructured.html FLATTEN is used to unnest semi-structured data. Don’t see an application for structured data as by definition it shouldn’t be nested. Question: 75 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: 76 Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.) A. The validation_mode option is used when creating an Internal Stage B. validation_mode=return_all_errors is a parameter of the copy command C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors Answer: B,D Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html Question: 77 Which Snowflake partner specializes in data catalog solutions? A. Alation B. DataRobot C. dbt D. Tableau Answer: A Explanation: Alation provides Data Cataloging functionality. They state they are the ‘One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html Question: 78 The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers A. The complexity of each query B. The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account C. The size of the data required for each query D. The tool that s executing the query Answer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html Question: 79 When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved: A. Concurrency B. Performance Answer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html Question: 80 True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet. A. True B. False Answer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html For More exams visit https://killexams.com/vendors-exam-list