Prepare with Snowflake : ARA-C01 exam braindumps as your best preparation materials

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 one task.
• C. Useone stream and two tasks.
• D. Usetwo streams and two tasks.

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 root level (HSM)
• B. At the table level (TMK)
• C. At the account level (AMK)
• D. At the micro-partition level

Two queries are run on the customer_address table:
create or replace TABLE CUSTOMER_ADDRESS ( CA_ADDRESS_SK NUMBER(38,0),
CA_ADDRESS_ID VARCHAR(16), CA_STREET_NUMBER VARCHAR(IO) CA_STREET_NAME
VARCHAR(60), CA_STREET_TYPE VARCHAR(15), CA_SUITE_NUMBER VARCHAR(10), CA_CITY VARCHAR(60), CA_COUNTY VARCHAR(30), CA_STATE VARCHAR(2), CA_ZIP VARCHAR(10), CA_COUNTRY VARCHAR(20), CA_GMT_OFFSET NUMBER(5,2), CA_LOCATION_TYPE VARCHAR(20) ); ALTER TABLE DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS ADD SEARCH OPTIMIZATION ON SUBSTRING(CA_ADDRESS_ID); Which queries will benefit from the use of the search optimization service? (Select TWO).

• A. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDNOT LIKE
  '%AAAAAAAAPHPPL%';
• B. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where CA_ADDRESS_ID= substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,16);
• C. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where substring
  (CA_ADDRESS_ID,1,8)= substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,8);
• D. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE '% PHPP%';
• E. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE '% BAAASKD%';

A 2 TB table with 400 columns is queried frequently to calculate average employee tenure by country and career level. The query exhibits poor partition pruning and runs on an X-Small warehouse.
What improvement meets the requirements with the LEAST operational overhead?

• A. Add clustering keys on COUNTRY and EMPLOYMENT_STATUS.
• B. Enable search optimization on equality predicates for COUNTRY and EMPLOYMENT_STATUS.
• C. Enable Query Acceleration Service (QAS).
• D. Build a materialized view for latest active employee records per country.

A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish:

What would be the output of this query?

• A. Table T_SALES_CLONE successfully created.
• B. Syntax error line 1 at position 58 unexpected 'at'.
• C. Time Travel data is not available for table T_SALES.
• D. The offset -> is not a valid clause in the clone operation.