A Data Engineer needs to know the details regarding the micro-partition layout for a table named invoice using a built-in function.
Which query will provide this information?
A. CALL SYSTEM$CLUSTERING_INFORMATION ('Invoice');
B. CALL $CLUSTERINS_INFORMATION('Invoice');
C. SELECT SYSTEM$CLUSTERING_INTFORMATICII ('Invoice' ) ;
D. SELECT $CLUSTERXNG_INFQRMATION ('Invoice')'
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Given the table sales which has a clustering key of column CLOSED_DATE which table function will return the average clustering depth for the SALES_REPRESENTATIVEcolumn for the North American region?
A.
B.
C.
D.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
At what isolation level are Snowflake streams?
A. Repeatable read
B. Read committed
C. Snapshot
D. Read uncommitted
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
Which system role is recommended for a custom role hierarchy to be ultimately assigned to?
A. USERADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. SYSTEMADMIN
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
A new customer table is created by a data pipeline in a Snowflake schema where MANAGED ACCESSenabled.
.... Can gran access to the CUSTOMER table? (Select THREE.)
A. The SECURITYADMIN role
B. The SYSADMIN role
C. The role that owns the customer table
D. The role that owns the database
E. The role that owns the schema
F. The USERADMIN role with the manage grants privilege
正解:A,D,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
A Data Engineer has written a stored procedure that will run with caller's rights. The Engineer has granted ROLEA right to use this stored procedure.
What is a characteristic of the stored procedure being called using ROLEA?
A. ROLEA will not be able to see the source code for the stored procedure even though the role has usage privileges on the stored procedure
B. The stored procedure must run with caller's rights it cannot be converted later to run with owner's rights
C. The stored procedure will run in the context (database and schema) where the owner created the stored procedure
D. If the stored procedure accesses an object that ROLEA does not have access to the stored procedure will fail
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
Which callback function is required within a JavaScript User-Defined Function (UDF) for it to execute successfully?
A. processRow ()
B. initialize ()
C. handler
D. finalize ()
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
Kamimura -
DEA-C01の内容は問題数も増えた感じで内容も充実しているし、SnowPro-Core早速勉強していきたいと思います!