Online Access Free ARA-C01 Exam Questions

A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?

• A.Masked data will be loaded into the new column.
• B.Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.
• C.Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.
• D.Unmasked data will be loaded in the new column.

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor.
What changes can be made to Improve the data loading performance?

• A.Change the file format from CSV to JSON.
• B.Create a multi-cluster warehouse and merge smaller files to create bigger files.
• C.Create a specific storage landing bucket to avoid file scanning.
• D.Increase the size of the virtual warehouse.

A retail company has over 3000 stores all using the same Point of Sale (POS) system. The company wants to deliver near real-time sales results to category managers. The stores operate in a variety of time zones and exhibit a dynamic range of transactions each minute, with some stores having higher sales volumes than others.
Sales results are provided in a uniform fashion using data engineered fields that will be calculated in a complex data pipeline. Calculations include exceptions, aggregations, and scoring using external functions interfaced to scoring algorithms. The source data for aggregations has over 100M rows.
Every minute, the POS sends all sales transactions files to a cloud storage location with a naming convention that includes store numbers and timestamps to identify the set of transactions contained in the files. The files are typically less than 10MB in size.
How can the near real-time results be provided to the category managers? (Select TWO).

• A.All files should be concatenated before ingestion into Snowflake to avoid micro-ingestion.
• B.A stream should be created to accumulate the near real-time data and a task should be created that runs at a frequency that matches the real-time analytics needs.
• C.A Snowpipe should be created and configured with AUTO_INGEST = true. A stream should be created to process INSERTS into a single target table using the stream metadata to inform the store number and timestamps.
• D.An external scheduler should examine the contents of the cloud storage location and issue SnowSQL commands to process the data at a frequency that matches the real-time analytics needs.
• E.The copy into command with a task scheduled to run every second should be used to achieve the near- real time requirement.

An Architect is using an event table associated with a Sales database (sales_db) to track logging and tracing of procedures and functions. The event table is also used to refresh dynamic tables.
A stored procedure causing issues resides in the Marketing database (marketing_db). Both databases are in the same Snowflake account. The Marketing database is not associated with a specific event table.
How can the Architect investigate the issue?

• A.Add a new event table and associate it with the Snowflake account.
• B.Query the event table SNOWFLAKE.TELEMETRY.EVENTS.
• C.Add a new event table and associate it with the Marketing database.
• D.Query the event table MARKETING_DB.TELEMETRY.EVENTS.

A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

• A.A copy command at regular intervals
• B.A pipe
• C.A stream
• D.An external table