ARA-C01 무료 덤프문제 온라인 액세스

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?

• A.Create a pipeline to write shared data to a cloud storage location in the target cloud provider.
• B.Company A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.
• C.Setup data replication to the region and cloud platform where the consumer resides.
• D.Ensure that all views are persisted, as views cannot be shared across cloud platforms.

The following chart represents the performance of a virtual warehouse over time:

A Data Engineer notices that the warehouse is queueing queries. The warehouse is sizeX-Small, theminimum and maximum cluster counts are set to 1, thescaling policy is set to standard, andauto-suspend is set to 10 minutes.
How can the performance be improved?

• A.Increase the size of the warehouse.
• B.Change the cluster settings.
• C.Change auto-suspend to a longer time frame.
• D.Change the scaling policy to economy.

An Architect needs to define a table structure for an unfamiliar semi-structured data set. The Architect wants to identify a list of distinct key names present in the semi-structured objects.
What function should be used?

• A.RESULT_SCAN
• B.INFER_SCHEMA
• C.FLATTEN with the RECURSIVE argument
• D.PARSE_JSON

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

• A.Users who are schema owners can grant object privileges in a managed access schema.
• B.Users who are database owners can grant object privileges in a managed access schema.
• C.Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.
• D.Users with the SYSADMIN role can grant object privileges in a managed access schema.
• E.Users who are object owners can grant object privileges in a managed access schema.

An Architect is designing a solution that will be used to process changed records in an orders table. Newly- inserted orders must be loaded into the f_orders fact table, which will aggregate all the orders by multiple dimensions (time, region, channel, etc.). Existing orders can be updated by the sales department within 30 days after the order creation. In case of an order update, the solution must perform two actions:
1. Update the order in the f_0RDERS fact table.
2. Load the changed order data into the special table ORDER _REPAIRS.
This table is used by the Accounting department once a month. If the order has been changed, the Accounting team needs to know the latest details and perform the necessary actions based on the data in the order_repairs table.
What data processing logic design will be the MOST performant?

• A.Usetwo streams and one task.
• B.Useone stream and two tasks.
• C.Usetwo streams and two tasks.
• D.Useone stream and one task.