The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

• A.Consolidate data in the company's data lake and use EXTERNAL TABLES.
• B.Create a raw database for landing and persisting raw data entering the data pipelines.
• C.Create a set of profile-specific databases that aligns data with usage patterns.
• D.Create a single star schema in a single database to support all consumers' requirements.
• E.Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

Comment: *

Name: *

Email: *

Verification: *

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It then joins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process.
On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developer needs a recommendation that does not increase compute costs to run this query.
What should the Architect recommend?

• A.Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The query results will then be cached and ready to respond quickly when the users re-issue the query.
• B.Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.
• C.Enable the search optimization service on the table. When the users execute the query, the search optimization service will automatically adjust the query execution plan based on the frequently-used parameters.
• D.Create a dedicated size Large warehouse for this particular set of queries. Create a new role that has USAGE permission on this warehouse and has the appropriate read permissions over the fact and dimension tables. Have users switch to this role and use this warehouse when they want to access this data.

Comment: *

Name: *

Email: *

Verification: *

What does a Snowflake Architect need to consider when implementing a Snowflake Connector for Kafka?

• A.Every Kafka message is in JSON or Avro format.
• B.The default retention time for Kafka topics is 14 days.
• C.The Kafka connector supports key pair authentication, OAUTH. and basic authentication (for example, username and password).
• D.The Kafka connector will create one table and one pipe to ingest data for each topic. If the connector cannot create the table or the pipe it will result in an exception.

Comment: *

Name: *

Email: *

Verification: *

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

• A.USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
• B.USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
• C.MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
• D.USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Assume role with OWNERSHIP on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
• B.Assume role with ALL PRIVILEGES on VPN_ACCESS_LOGS and ADD SEARCH OPTIMIZATION in the SECURITY_LOGS schema.
• C.Assume role with ALL PRIVILEGES including ADD SEARCH OPTIMIZATION in the SECURITY LOGS schema.
• D.Assume role with OWNERSHIP on future tables and ADD SEARCH OPTIMIZATION on the SECURITY_LOGS schema.

Comment: *

Name: *

Email: *

Verification: *