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

• A. Use the Enterprise edition of Snowflake.
• B. Use Dynamic Data Masking.
• C. Create a secure view.
• D. Define row access policies.
• E. Create a materialized view.
• F. Use the Business-Critical edition of Snowflake.

A company wants to Integrate its main enterprise identity provider with federated authentication with Snowflake.
The authentication integration has been configured and roles have been created in Snowflake. However, the users are not automatically appearing in Snowflake when created and their group membership is not reflected in their assigned rotes.
How can the missing functionality be enabled with the LEAST amount of operational overhead?

• A. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM. users will automatically get created and their group membership will be reflected as roles In Snowflake.
• B. SCIM must be enabled between the identity provider and Snowflake. Once both are synchronized through SCIM, their groups will get created as group accounts in Snowflake and the proper roles can be granted.
• C. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users and roles.
• D. OAuth must be configured between the identity provider and Snowflake. Then the authorization server must be configured with the right mapping of users, and the resource server must be configured with the right mapping of role assignment.

An Architect for a multi-national transportation company has a system that is used to check the weather conditions along vehicle routes. The data is provided to drivers.
The weather information is delivered regularly by a third-party company and this information is generated as JSON structure. Then the data is loaded into Snowflake in a column with a VARIANT data type. This table is directly queried to deliver the statistics to the drivers with minimum time lapse.
A single entry includes (but is not limited to):
- Weather condition; cloudy, sunny, rainy, etc.
- Degree
- Longitude and latitude
- Timeframe
- Location address
- Wind
The table holds more than 10 years' worth of data in order to deliver the statistics from different years and locations. The amount of data on the table increases every day.
The drivers report that they are not receiving the weather statistics for their locations in time.
What can the Architect do to deliver the statistics to the drivers faster?

• A. Divide the table into several tables for each year by using the timeframe information from the JSON dataset in order to process the queries in parallel.
• B. Add search optimization service on the variant column for longitude and latitude in order to query the information by using specific metadata.
• C. Divide the table into several tables for each location by using the location address information from the JSON dataset in order to process the queries in parallel.
• D. Create an additional table in the schema for longitude and latitude. Determine a regular task to fill this information by extracting it from the JSON dataset.

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

• A. Shared databases are read-only.
• B. Shared databases are not supported by Time Travel.
• C. Shared databases cannot be cloned.
• D. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
• E. Shared databases must be refreshed in order for new data to be visible.
• F. Shared databases can also be created as transient databases.

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported.
What could be causing this?

• A. The order of the keys in the JSON was changed.
• B. There were JSON nulls in the recent data imports.
• C. There were variations in string lengths for the JSON values in the recent data imports.
• D. The recent data imports contained fewer fields than usual.