Online Access Free ARA-R01 Practice Test

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?

• A.Set the share_restriction parameter on the shared object to false.
• B.By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.
• C.The healthcare company will need to change the institute's Snowflake edition in the accounts panel.
• D.Contact Snowflake and they will execute the share request for the healthcare company.

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include:
1) Finance and Vendor Management team members who require reporting and visualization
2) Data Science team members who require access to raw data for ML model development
3) Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

• A.Create a single star schema in a single database to support all consumers' requirements.
• B.Consolidate data in the company's data lake and use EXTERNAL TABLES.
• C.Create a set of profile-specific databases that aligns data with usage patterns.
• D.Create a raw database for landing and persisting raw data entering the data pipelines.
• E.Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1-> show grants to user user_01;
Command 2 ~> show grants on user user 01;
What inferences can be made about these commands?

• A.Command 1 defines all the grants which are given to user_01
  Command 2 defines which role owns user 01
• B.Command 1 defines which user owns user_01
  Command 2 defines all the grants which have been given to user_01
• C.Command 1 defines which role owns user_01
  Command 2 defines all the grants which have been given to user_01
• D.Command 1 defines all the grants which are given to user_01 Command 2 defines which user owns user_01

A company is following the Data Mesh principles, including domain separation, and chose one Snowflake account for its data platform.
An Architect created two data domains to produce two data products. The Architect needs a third data domain that will use both of the data products to create an aggregate data product. The read access to the data products will be granted through a separate role.
Based on the Data Mesh principles, how should the third domain be configured to create the aggregate product if it has been granted the two read roles?

• A.Create a hierarchy between the two read roles.
• B.Use secondary roles for all users.
• C.Request that the two data domains share data using the Data Exchange.
• D.Request a technical ETL user with the sysadmin role.

An Architect needs to meet a company requirement to ingest files from the company's AWS storage accounts into the company's Snowflake Google Cloud Platform (GCP) account. How can the ingestion of these files into the company's Snowflake account be initiated? (Select TWO).

• A.Configure AWS Simple Notification Service (SNS) to notify Snowpipe when new files have arrived in Amazon S3 storage.
• B.Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.
• C.Configure the client application to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 Glacier storage.
• D.Configure the client application to issue a COPY INTO <TABLE> command to Snowflake when new files have arrived in Amazon S3 Glacier storage.
• E.Create an AWS Lambda function to call the Snowpipe REST endpoint when new files have arrived in Amazon S3 storage.