DEA-C02 practice questions 81–90

1. Question 81 · 126 in bank

   Data is loaded into a staging table every day. From there, several departments perform transformations on the data and load it into different production tables. How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

   • ACreate it as an external table, which is not covered by Time Travel.
   • BCreate it as a transient table with a retention time of 0 days.
   • CCreate it as a temporary table with a retention time of 0 days.
   • DCreate it as a permanent table with a retention time of 0 days.

   Show answer

   Answer: B

   Next question

2. Question 82 · 126 in bank

   A Data Engineer needs to be able to create new databases and objects as required for a Proof of Concept (POC). The sandbox Snowflake account where the POC is tested does not have Role-Based Access Control (RBAC) in place, but it belongs to an organization where some other accounts have RBAC. What is the LEAST-privileged system role that needs to be granted to this Engineer so they can work on this POC?

   • AORGADMIN
   • BPUBLIC
   • CSECURITYADMIN
   • DSYSADMIN

   Show answer

   Answer: D

   Next question

3. Question 83 · 126 in bank

   A Data Engineer has created two custom roles, MARKETING_ROLE and FINANCE_ROLE, to be granted to the users of an application. According to best practices, what action should be taken next?

   • AUse the USERADMIN role to give all the required grants to the users.
   • BUse the SECURITYADMIN role to configure the required parameters for the users at the account level.
   • CUse the ACCOUNTADMIN role to create the new users that will be granted the new roles.
   • DAssign the custom roles to the SYSADMIN role.

   Show answer

   Answer: D

   Next question

4. Question 84 · 126 in bank

   Select 2

   How can a directory table be used when working with unstructured data? (Choose two.)

   • AFile access URLs can be shared with collaborators and partners.
   • BData stored in an external stage can be queried as if the data was inside a table in Snowflake.
   • CAll unstructured files on a stage can be queried using the SELECT * FROM DIRECTORY(@); command.
   • DAll unstructured files on a stage can be queried using the SELECT * FROM @; command.
   • EA directory table can be joined with other tables to produce a view of unstructured data that combines the file URLs with the file metadata.

   Show answer

   Answer: CE

   Next question

5. Question 85 · 126 in bank

   A Data Engineer is using a Snowflake Standard edition and has an external function in schema A, a view in schema B, and then creates a SHARE and adds the view to the SHARE as follows: create secure view B.my_shared_view as select A.my_external_function(x) ...; create share things_to_share; grant select on view my_shared_view to share things_to_share; What will be true about this command?

   • AThe external function will not be supported in the view.
   • BThe external function will not be supported in the share.
   • CThe external function will not be supported in the schema cross-reference.
   • DThe external function is not supported in the Standard edition.

   Show answer

   Answer: B

   Next question

6. Question 86 · 126 in bank

   A Data Engineer is reviewing Python data pipeline code that is dynamically scaling warehouse HOL_WH:

   

   What effect is the WAIT_FOR_COMPLETION clause having on the pipeline?

   • AThe initial ALTER WAREHOUSE command will be blocked until all existing processes on the HOL_WH have completed.
   • BThe second ALTER WAREHOUSE command will be blocked until the data processing code between the two ALTER WAREHOUSE statements have completed.
   • CThe WAIT_FOR_COMPLETION clause will block the return of the first ALTER WAREHOUSE command until the resize has finished provisioning all compute resources.
   • DThe WAIT_FOR_COMPLETION clause will allow the processes to run in parallel while the first resize finishes provisioning the compute resources.

   Show answer

   Answer: C

   Next question

7. Question 87 · 126 in bank

   Which command will retrieve results for all objects of a row access policy db1.policies.objectslist at the database level?

   • ASELECT * FROM TABLE( db1.ACCOUNT_USAGE.POLICY_REFERENCES( POLICY_NAME=>'db1.policies.objectslist' ) );
   • BSELECT * FROM TABLE( db1.INFORMATION_SCHEMA.POLICY_REFERENCES( POLICY_NAME=>'db1.policies.objectslist' ) );
   • CSELECT * FROM TABLE( db1.ACCOUNT_USAGE.ROW_ACCESS_POLICIES( POLICY_NAME=>'db1.policies.objectslist' ) );
   • DSELECT * FROM TABLE( db1.INFORMATION_SCHEMA.POLICY_REFERENCES( REF_ENTITY_NAME => 'db1.policies.objectslist', REF_ENTITY_DOMAIN => 'policy' ) );

   Show answer

   Answer: B

   Next question

8. Question 88 · 126 in bank

   A Data Engineer is querying a large table (+100 million rows) with the following SQL: select name , address , datediff(year, birthdate, current_date()) from customers; The Engineer notices that the results cache is not being used on subsequent executions of the query. The underlying table does not change and the data is not updated in between query executions. What is causing this to occur?

   • ACalculations are not stored in the results cache.
   • BLarge results are not stored in the results cache.
   • CDate functions are not stored in the results cache.
   • DNon-deterministic calculations are not stored in the results cache.

   Show answer

   Answer: D

   Next question

9. Question 89 · 126 in bank

   A Data Engineer needs to share customer data using an API with a partner application. The API will accept the JSON payload using this structure:

   

   All information can be found in table, CUSTOMER. There may be multiple rows for a single customer with different contact details. Which query will prepare the JSON payload in the required format?

   • A//IMG//
   • B//IMG//
   • C//IMG//
   • D//IMG//

   Show answer

   Answer: B

   Next question

10. Question 90 · 126 in bank

    This query was executed: SELECT SYSTEM$EXPLAIN_PLAN_JSON( 'SELECT Z1.ID, Z2.ID FROM Z1, Z2 WHERE Z2.ID = Z1.ID' ) AS explain_plan; What information will be provided in the results?

    • AAverage partition overlap
    • BTotal partitions scanned
    • CAverage clustering depth
    • DClustering errors

    Show answer

    Answer: B

    Next question

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

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