DEA-C02 practice questions 31–40

1. Question 31 · 126 in bank

   The following chart represents the performance of a virtual warehouse over time:

   

   A Data Engineer notices that the warehouse is queueing queries. The warehouse is size X-Small, the minimum and maximum cluster counts are set to 1, the scaling policy is set to standard, and auto-suspend is set to 10 minutes. How can the performance be improved?

   • AChange the cluster settings.
   • BIncrease the size of the warehouse.
   • CChange the scaling policy to economy.
   • DChange auto-suspend to a longer time frame.

   Show answer

   Answer: A

   Next question

2. Question 32 · 126 in bank

   A secure function returns data coming through an inbound share. What will happen if a Data Engineer tries to assign USAGE privileges on this function to an outbound share?

   • AAn error will be returned because the Engineer cannot share data that has already been shared.
   • BAn error will be returned because only views and secure stored procedures can be shared.
   • CAn error will be returned because only secure functions can be shared with inbound shares.
   • DThe Engineer will be able to share the secure function with other accounts.

   Show answer

   Answer: A

   Next question

3. Question 33 · 126 in bank

   Select 2

   Which functions will compute a 'fingerprint' over an entire table, query result, or window to quickly detect changes to table contents or query results? (Choose two.)

   • AHASH(*)
   • BHASH_AGG(*)
   • CHASH_AGG(<expr>, <expr>)
   • DHASH_AGG_COMPARE(*)
   • EHASH_COMPARE(*)

   Show answer

   Answer: BC

   Next question

4. Question 34 · 126 in bank

   Which stages support external tables?

   • AInternal stages only; within a single Snowflake account
   • BInternal stages only; from any Snowflake account in the organization
   • CExternal stages only; from any region, and any cloud provider
   • DExternal stages only; only on the same region and cloud provider as the Snowflake account

   Show answer

   Answer: C

   Next question

5. Question 35 · 126 in bank

   A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a database named test and a schema named Extract (case-sensitive). Which query will provide the status of the pipe?

   • ASELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
   • BSELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
   • CSELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
   • DSELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");

   Show answer

   Answer: B

   Next question

6. Question 36 · 126 in bank

   Select 2

   Company A and Company B both have Snowflake accounts. Company A's account is hosted on a different cloud provider and region than Company B's account. Companies A and B are not in the same Snowflake organization. How can Company A share data with Company B? (Choose two.)

   • ACreate a share within Company A's account and add Company B's account as a recipient of that share.
   • BCreate a share within Company A's account, and create a reader account that is a recipient of the share. Grant Company B access to the reader account.
   • CUse database replication to replicate Company A's data into Company B's account. Create a share within Company B's account and grant users within Company B's account access to the share.
   • DCreate a new account within Company A's organization in the same cloud provider and region as Company B's account. Use database replication to replicate Company A's data to the new account. Create a share within the new account, and add Company B's account as a recipient of that share.
   • ECreate a separate database within Company A's account to contain only those data sets they wish to share with Company B. Create a share within Company A's account and add all the objects within this separate database to the share. Add Company B's account as a recipient of the share.

   Show answer

   Answer: AD

   Next question

7. Question 37 · 126 in bank

   A Data Engineer is trying to load the following rows from a CSV file into a table in Snowflake with the following structure:

   

   

   The engineer is using the following COPY INTO statement:

   

   However, the following error is received: Number of columns in file (6) does not match that of the corresponding table (3), use file format option error_on_column_count_mismatch=false to ignore this error File 'address.csv.gz', line 3, character 1 Row 1 starts at line 2, column "STGCUSTOMER"[6] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. Which file format option should be used to resolve the error and successfully load all the data into the table?

   • AESCAPE_UNENCLOSED FIELD = '\\'
   • BERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
   • CFIELD_DELIMITER = ','
   • DFIELD_OPTIONALLY_ENCLOSED_BY = '"'

   Show answer

   Answer: D

   Next question

8. Question 38 · 126 in bank

   A Data Engineer is working on a continuous data pipeline which receives data from Amazon Kinesis Firehose and loads the data into a staging table which will later be used in the data transformation process. The average file size is 300-500 MB. The Engineer needs to ensure that Snowpipe is performant while minimizing costs. How can this be achieved?

   • AIncrease the size of the virtual warehouse used by Snowpipe.
   • BSplit the files before loading them and set the SIZE_LIMIT option to 250 MB.
   • CChange the file compression size and increase the frequency of the Snowpipe loads.
   • DDecrease the buffer size to trigger delivery of files sized between 100 to 250 MB in Kinesis Firehose.

   Show answer

   Answer: D

   Next question

9. Question 39 · 126 in bank

   Within a Snowflake account. permissions have been defined with custom roles and role hierarchies. To set up column-level masking using a role in the hierarchy of the current user, what command would be used?

   • ACURRENT_ROLE
   • BINVOKER_ROLE
   • CIS_ROLE_IN_SESSION
   • DIS_GRANTED_TO_INVOKER_ROLE

   Show answer

   Answer: D

   Next question

10. Question 40 · 126 in bank

    Select 2

    Assuming a Data Engineer has all appropriate privileges and context, which statements would be used to assess whether the User-Defined Function (UDF), MYDATABASE.SALES.REVENUE_BY_REGION, exists and is secure? (Choose two.)

    • ASHOW USER FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES;
    • BSELECT IS_SECURE FROM SNOWFLAKE.INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'SALES' AND FUNCTION_NAME = 'REVENUE_BY_REGION';
    • CSELECT IS_SECURE FROM INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'SALES' AND FUNCTION_NAME = 'REVENUE_BY_REGION';
    • DSHOW EXTERNAL FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES;
    • ESHOW SECURE FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES;

    Show answer

    Answer: AC

    Next question

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

DEA-C02 practice, question 31. 126 questions available.