COF-C02 practice questions 951–960

1. Question 951 · 1323 in bank

   Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

   • AGET @%TBL_EMPLOYEE 'file://C:\folder with space\';
   • BGET @%TBL_EMPLOYEE 'file://C:/folder with space/';
   • CPUT 'file://C:\folder with space\*' @%TBL_EMPLOYEE;
   • DPUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;

   Show answer

   Answer: B

   Explanation

   https://docs.snowflake.com/en/sql-reference/sql/get If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).

   Source: Adapted from community discussion — singhks

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

2. Question 952 · 1323 in bank

   Select 2

   How can the COPY command be used to unload data from a table to an internal stage?

   • ACOPY INTO [location]
   • BCOPY INTO [table]
   • CCOPY INTO [location] with single-true
   • DCOPY INTO S3://[bucket]

   Show answer

   Answer: AB

   Next question

3. Question 953 · 1323 in bank

   True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Next question

4. Question 954 · 1323 in bank

   How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

   • AA single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
   • BA single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
   • CA single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
   • DMultiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

   Show answer

   Answer: B

   References

   • Snowflake documentation

   Next question

5. Question 955 · 1323 in bank

   Which command should be used to unload all the rows from a table into one or more files in a named stage?

   • ACOPY INTO
   • BGET
   • CINSERT INTO
   • DPUT

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

6. Question 956 · 1323 in bank

   Which command is used to unload data from a table or move a query result to a stage?

   • ACOPY INTO
   • BGET
   • CMERGE
   • DPUT

   Show answer

   Answer: A

   Next question

7. Question 957 · 1323 in bank

   Select 2

   What privileges are necessary for a consumer in the Data Exchange to make a request and receive data? (Choose two.)

   • ACREATE DATABASE
   • BIMPORT SHARE
   • COWNERSHIP
   • DREFERENCE_USAGE
   • EUSAGE

   Show answer

   Answer: AB

   Explanation

   https://other-docs.snowflake.com/en/collaboration/consumer-becoming Set Up Required Privileges To access a listing, you must use the ACCOUNTADMIN role or another role with the CREATE DATABASE and IMPORT SHARE privileges. To pay for a paid listing, your role must also have the PURCHASE DATA EXCHANGE LISTING privilege.

   Source: Adapted from community discussion — singhks

   Next question

8. Question 958 · 1323 in bank

   Select 2

   What are benefits of using Snowpark with Snowflake? (Choose two.)

   • ASnowpark uses a Spark engine to generate optimized SQL query plans.
   • BSnowpark automatically sets up Spark within Snowflake virtual warehouses.
   • CSnowpark does not require that a separate cluster be running outside of Snowflake.
   • DSnowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
   • ESnowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

   Show answer

   Answer: CE

   Explanation

   https://docs.snowflake.com/en/developer-guide/snowpark/index Benefits When Compared with the Spark Connector In comparison to using the Snowflake Connector for Spark, developing with Snowpark includes the following benefits: Support for interacting with data within Snowflake using libraries and patterns purpose built for different languages without compromising on performance or functionality. Support for authoring Snowpark code using local tools such as Jupyter, VS Code, or IntelliJ. Support for pushdown for all operations, including Snowflake UDFs. This means Snowpark pushes down all data transformation and heavy lifting to the Snowflake data cloud, enabling you to efficiently work with data of any size. No requirement for a separate cluster outside of Snowflake for computations. All of the computations are done within Snowflake. Scale and compute management are handled by Snowflake.

   Source: Adapted from community discussion — ukpino

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 959 · 1323 in bank

   Select 2

   What are Snowflake best practices when assigning the ACCOUNTADMIN role to users? (Choose two.)

   • AThe ACCOUNTADMIN role should be assigned to at least two users.
   • BThe ACCOUNTADMIN role should be used to create Snowflake objects.
   • CThe ACCOUNTADMIN role should be used for running automated scripts.
   • DThe ACCOUNTADMIN role should be given to any user who needs a high level of authority.
   • EAll users assigned the ACCOUNTADMIN role should use Multi-Factor Authentication (MFA).

   Show answer

   Answer: AE

   Next question

10. Question 960 · 1323 in bank

    What is a recommended approach for optimizing query performance in Snowflake?

    • AUse subqueries whenever possible.
    • BUse a large number of joins to combine data from multiple tables.
    • CSelect all columns from tables, even if they are not needed in the query.
    • DUse a smaller number of larger tables rather than a larger number of smaller tables.

    Show answer

    Answer: D

    Explanation

    The correct answer is D. Use a smaller number of larger tables rather than a larger number of smaller tables. Here are some of the reasons why using a smaller number of larger tables can improve query performance in Snowflake: Reduced data movement: When you join multiple tables, Snowflake needs to move data between the tables. This can be a bottleneck, especially if the tables are large. Using a smaller number of larger tables can reduce the amount of data that needs to be moved, which can improve performance. Improved caching: Snowflake caches data in memory. When you use a smaller number of larger tables, the data is more likely to be cached in memory, which can also improve performance. Simplified query planning: Snowflake's query planner is more efficient when it has to plan queries for a smaller number of tables. This can also improve performance.

    Source: Adapted from community discussion — arnabbis4u

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 951. 1323 questions available.