Q56. You have create a task as below
CREATE TASK mytask1
WAREHOUSE = mywh
SCHEDULE = ‘5 minute’
WHEN
SYSTEM$STREAM_HAS_DATA(‘MYSTREAM’)
AS
INSERT INTO mytable1(id,name) SELECT id, name FROM mystream WHERE METADATA$ACTION = ‘INSERT’;
Which statement is true below?

Q57. Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

Q58. At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

Q59. A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

Q60. COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV

Q61. Which of the following are characteristics of how row access policies can be applied to external tables?
(Choose three.)

Q62. How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

Q63. Which copy options are not supported by CREATE PIPE…AS COPY FROM command?

Q64. What conditions should be true for a table to consider search optimization

Q65. Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Select TWO).

Q66. An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
How can this requirement be met?

Q67. Refreshing a secondary database is not allowed in the following circumstances

Q68. You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.
What is the best option?

Q69. You have create a table in snowflake as below
CREATE TABLE EMPLOYEE(EMPLOYEE_NAME STRING, SALARY NUMBER); When you do a DESCRIBE TABLE EMPLOYEE, what will you see as the data type of EMPLOYEE_NAME?

Q70. Let’s say that you have two JSONs as below
1. {“stuId”:2000, “stuName”:”Amy”}
2. {“stuId”:2000,”stuCourse”:”Snowflake”}
How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2

Q71. Multi-cluster warehouses are best utilized for

Q72. An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

Q73. How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)