Online Access Free ARA-C01 Exam Questions

A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.
What would be the MOST efficient way to load data from the vendor into Snowflake?

• A.Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.
• B.Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.
• C.Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure.
• D.Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.

Which parameters can only be set at the account level? (Select TWO).

• A.MAX_CONCURRENCY_LEVEL
• B.PERIODIC_DATA_REKEYING
• C.DATA_RETENTION_TIME_IN_DAYS
• D.ENFORCE_SESSION_POLICY
• E.TIMESTAMP_INPUT_FORMAT

A company is trying to Ingest 10 TB of CSV data into a Snowflake table using Snowpipe as part of Its migration from a legacy database platform. The records need to be ingested in the MOST performant and cost- effective way.
How can these requirements be met?

• A.Use purge = TRUE in the copy into command.
• B.Use on error = SKIP_FILE in the copy into command.
• C.Use ON_ERROR = continue in the copy into command.
• D.Use FURGE = FALSE in the copy into command.

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

• A.SYSTEM$CLUSTERING_USAGE
• B.SYSTEM$CLUSTERING_DEPTH
• C.SYSTEM$CLUSTERING_KEYS
• D.SYSTEM$CLUSTERING_PERCENT
• E.SYSTEM$CLUSTERING_INFORMATION

Which Snowflake data modeling approach is designed for BI queries?

• A.Snowflake schema
• B.Data Vault
• C.Star schema
• D.3 NF