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

NO.61 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?

NO.62 While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?

NO.63 You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data
cache.
Why?

NO.64 Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost

NO.65 You are a snowflake architect in an organization. The business team came to to deploy an use case which requires you to load some data which they can visualize through tableau. Everyday new data comes in and the old data is no longer required.
What type of table you will use in this case to optimize cost

NO.66 A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

NO.67 An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows:
1) Use Tri-Secret Secure in Snowflake
2) Share some information stored in a view with another Snowflake customer
3) Hide portions of sensitive information from some columns
4) Use zero-copy cloning to refresh the non-production environment from the production environment To meet these requirements, which design elements must be implemented? (Choose three.)

NO.68 If your role does not own the share, but owns the objects in the share, how can you block access to the objects

NO.69 You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days.
What will be the impact on the table data?

NO.70 Running EXPLAIN on a query does not require a running warehouse

NO.71 Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice

NO.72 Select the true statements about TASKS

NO.73 Search optimization does not support Materialized views and External Tables

NO.74 Snowflake supports the following query performance optimizing methods

NO.75 How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

NO.76 What Snowflake features should be leveraged when modeling using Data Vault?

NO.77 create or replace table result_scan_table as
select * from table(result_scan(last_query_id()));
Will the above query cost you any compute credits?

NO.78 Dynamic data masking is supported in which editions of snowflake

NO.79 Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only

NO.80 A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses

NO.81 VALIDATION_MODE does not support COPY statements that transform data during a load

NO.82 Which semi-structured data function returns an OBJECT constructed from the arguments.