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?
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.
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.)
