ARA-C01最も有効な質問と解答で勉強

An Architect needs to design a Snowflake account and database strategy to store and analyze large amounts of structured and semi-structured data. There are many business units and departments within the company. The requirements are scalability, security, and cost efficiency.
What design should be used?

• A. Use Snowflake's data lake functionality to store and analyze all data in a central location, without the need for structured schemas or indexes
• B. Create a single Snowflake account and database for all data storage and analysis needs, regardless of data volume or complexity.
• C. Use a centralized Snowflake database for core business data, and use separate databases for departmental or project-specific data.
• D. Set up separate Snowflake accounts and databases for each department or business unit, to ensure data isolation and security.

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 task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.
• B. 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.
• 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 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.

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

• A. At the table level (TMK)
• B. At the micro-partition level
• C. At the root level (HSM)
• D. At the account level (AMK)

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

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

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. Publish product_category and product_details data sets on the Snowflake Marketplace.
• D. Use Secure Data Sharing with an S3 bucket as a destination.