← Back to exam page

ARA-C01 – SnowPro Advanced: Architect Certification Exam

Loading demo links...

Showing 7–9 of 10 questions

Question 7

What is a valid object hierarchy when building a Snowflake environment?

Select an option, then click Submit answer.

  • ○

    Account --> Database --> Schema --> Warehouse
  • ○

    Organization --> Account --> Database --> Schema --> Stage
  • ○

    Account --> Schema > Table --> Stage
  • ○

    Organization --> Account --> Stage --> Table --> View
Question 8

What integration object should be used to place restrictions on where data may be exported?

Select an option, then click Submit answer.

  • ○

    Stage integration
  • ○

    Security integration
  • ○

    Storage integration
  • ○

    API integration
Question 9

A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.

The data pipeline needs to run continuously ang efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.

Which design will meet these requirements?

Select an option, then click Submit answer.

  • ○

    Ingest the data using COPY INTO and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
  • ○

    Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
  • ○

    Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector. Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.
  • ○

    Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.