SnowPro Core COF-C02 Dumps (V16.02) with COF-C02 Free Dumps (Part 2, Q41-Q80): Help You Verify the Most Current Learning Resource

1. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

2. Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

3. A user has 10 files in a stage containing new customer data.

The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

4. 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?

5. What happens when a cloned table is replicated to a secondary database? (Select TWO)

6. Which data types does Snowflake support when querying semi-structured data? (Select TWO)

A. VARIANT

B. ARRAY

C. VARCHAR

D. XML

E. BLOB

7. Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

8. A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

9. What are the default Time Travel and Fail-safe retention periods for transient tables?

10. What is a best practice after creating a custom role?

11. Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

12. Will data cached in a warehouse be lost when the warehouse is resized?

13. Which Snowflake partner specializes in data catalog solutions?

14. What is the MOST performant file format for loading data in Snowflake?

15. Which copy INTO command outputs the data into one file?

16. Where would a Snowflake user find information about query activity from 90 days ago?

17. Which Snowflake technique can be used to improve the performance of a query?

18. User-level network policies can be created by which of the following roles? (Select TWO).

19. Which command can be used to load data into an internal stage?

20. What happens when an external or an internal stage is dropped? (Select TWO).

21. How long is Snowpipe data load history retained?

22. In which use cases does Snowflake apply egress charges?

23. Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

24. Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

25. Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

26. In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

27. A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

28. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

29. Which stage type can be altered and dropped?

30. Which command can be used to stage local files from which Snowflake interface?

31. What is the recommended file sizing for data loading using Snowpipe?

32. Which services does the Snowflake Cloud Services layer manage? (Select TWO).

33. What data is stored in the Snowflake storage layer? (Select TWO).

34. In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

35. What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

36. What is a responsibility of Snowflake's virtual warehouses?

37. Which of the following compute resources or features are managed by Snowflake? (Select TWO).

38. What happens when a virtual warehouse is resized?

39. A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

40. Which of the following describes how clustering keys work in Snowflake?