다운로드 Snowflake : ARA-R01 질문 & 답 PDF & Test Software

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 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.
• B. Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.
• C. Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.
• D. Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.

What step will im the performance of queries executed against an external table?

• A. Shorten the names of the source files.
• B. Use an internal stage instead of an external stage to store the source files.
• C. Convert the source files' character encoding to UTF-8.
• D. Partition the external table.

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. 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.
• 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. The copy into command with a task scheduled to run every second should be used to achieve the near-real time requirement.
• D. 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.
• E. All files should be concatenated before ingestion into Snowflake to avoid micro-ingestion.

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

• A. The UPSERT command
• B. The CHANGE_DATA_CAPTURE command
• C. A STREAM object
• D. The CHANGES clause
• E. The MERGE command

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?

• A. Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.
• B. Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.
• C. Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.
• D. Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.