ARA-C01 Exam Question 106

Let's say that you have two JSONs as below
1. {"stuId":2000, "stuName":"Amy"}
2. {"stuId":2000,"stuCourse":"Snowflake"}
How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2
  • ARA-C01 Exam Question 107

    A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the partner should have access to the records.
    The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
    Which design will be the MOST cost-effective and secure, while using the required Snowflake features?
  • ARA-C01 Exam Question 108

    An Architect needs to allow a user to create a database from an inbound share.
    To meet this requirement, the user's role must have which privileges? (Choose two.)
  • ARA-C01 Exam Question 109

    The diagram shows the process flow for Snowpipe auto-ingest with Amazon Simple Notification Service (SNS) with the following steps:
    Step 1: Data files are loaded in a stage.
    Step 2: An Amazon S3 event notification, published by SNS, informs Snowpipe - by way of Amazon Simple Queue Service (SQS) - that files are ready to load. Snowpipe copies the files into a queue.
    Step 3: A Snowflake-provided virtual warehouse loads data from the queued files into the target table based on parameters defined in the specified pipe.

    If an AWS Administrator accidentally deletes the SQS subscription to the SNS topic in Step 2, what will happen to the pipe that references the topic to receive event messages from Amazon S3?
  • ARA-C01 Exam Question 110

    What is a characteristic of event notifications in Snowpipe?