ARA-C01 Exam Question 46

Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk
  • ARA-C01 Exam Question 47

    An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
    What should the Architect do to enable the Snowflake search optimization service on this table?
  • ARA-C01 Exam Question 48

    Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)
  • ARA-C01 Exam Question 49

    You have an inventory table. You created two views on this table. The views look like as below
    CREATE VIEW NON_SECURE_INVENTORY AS
    SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
    FROM INVENTORY
    WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
    CREATE SECURE VIEW SECURE_INVENTORY AS
    SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
    FROM INVENTORY
    WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
    You ran the below queries
    ALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cache
    SELECT * FROM NON_SECURE_INVENTORY WHERE BIBNUMBER =511784; SELECT * FROM SECURE_INVENTORY WHERE BIBNUMBER =511784;
    The query profile for the first query looks as below

    However, the query profile for the second one looks like as below

    Both the views use the same columns from the same underlying view. So, why is this difference in query profiles.
  • ARA-C01 Exam Question 50

    What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)