Prep and try our ARA-C01 valid and latest training questions & answers

A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the partner should have access to the records.
The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
Which design will be the MOST cost-effective and secure, while using the required Snowflake features?

• A. Create a database user for the partner and give them access to the required data sets.
• B. Create a reader account for the partner and share the data sets as secure views.
• C. Use Secure Data Sharing with an S3 bucket as a destination.
• D. Publish product_category and product_details data sets on the Snowflake Marketplace.

An Architect is designing Snowflake architecture to support fast Data Analyst reporting. To optimize costs, the virtual warehouse is configured to auto-suspend after 2 minutes of idle time. Queries are run once in the morning after refresh, but later queries run slowly.
Why is this occurring?

• A. The warehouse was not configured as a multi-cluster warehouse.
• B. The warehouse is not large enough.
• C. The warehouse was not created with USE_CACHE = TRUE.
• D. When the warehouse was suspended, the cache was dropped.

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.
What is the reason for this?

• A. The query is reading from remote storage.
• B. The query is queued for execution.
• C. The query has overly complex logic.
• D. The query is processing a very large 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 cannot be cloned.
• B. Shared databases are read-only.
• C. Shared databases are not supported by Time Travel.
• D. Shared databases can also be created as transient databases.
• E. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
• F. Shared databases must be refreshed in order for new data to be visible.

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