ARA-C01 practice questions 81–90

1. Question 81 · 193 in bank

   Select 2

   Which Snowflake objects can be used in a data share? (Choose two.)

   • AStandard view
   • BSecure view
   • CStored procedure
   • DExternal table
   • EStream

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

2. Question 82 · 193 in bank

   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?

   • AAsk the vendor to create a Snowflake account, load the data into Snowflake and create a data share.
   • BCreate an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.
   • CCopy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.
   • DCreate 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.

   Show answer

   Answer: B

   Next question

3. Question 83 · 193 in bank

   How can the Snowpipe REST API be used to keep a log of data load history?

   • ACall insertReport every 20 minutes, fetching the last 10,000 entries.
   • BCall loadHistoryScan every minute for the maximum time range.
   • CCall insertReport every 8 minutes for a 10-minute time range.
   • DCall loadHistoryScan every 10 minutes for a 15-minute time range.

   Show answer

   Answer: C

   Explanation

   By calling this command repeatedly, it is possible to see the full history of events on a pipe over time. Note that the command must be called often enough to not miss events. Events are retained for a maximum of 10 minutes. https://docs.snowflake.com/en/user-guide/data-load-snowpipe-rest-apis#endpoint-insertreport

   Source: Adapted from community discussion — Acaer

   References

   • Snowflake documentation

   Next question

4. Question 84 · 193 in bank

   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?

   

   • AThe pipe will continue to receive the messages as Snowflake will automatically restore the subscription to the same SNS topic and will recreate the pipe by specifying the same SNS topic name in the pipe definition.
   • BThe pipe will no longer be able to receive the messages and the user must wait for 24 hours from the time when the SNS topic subscription was deleted. Pipe recreation is not required as the pipe will reuse the same subscription to the existing SNS topic after 24 hours.
   • CThe pipe will continue to receive the messages as Snowflake will automatically restore the subscription by creating a new SNS topic. Snowflake will then recreate the pipe by specifying the new SNS topic name in the pipe definition.
   • DThe pipe will no longer be able to receive the messages. To restore the system immediately, the user needs to manually create a new SNS topic with a different name and then recreate the pipe by specifying the new SNS topic name in the pipe definition.

   Show answer

   Answer: D

   References

   • Snowflake documentation

   Next question

5. Question 85 · 193 in bank

   When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

   

   • AAt the root level (HSM)
   • BAt the account level (AMK)
   • CAt the table level (TMK)
   • DAt the micro-partition level

   Show answer

   Answer: B

   Next question

6. Question 86 · 193 in bank

   Select 2

   What are characteristics of the use of transactions in Snowflake? (Choose two.)

   • AExplicit transactions can contain DDL, DML, and query statements.
   • BThe AUTOCOMMIT setting can be changed inside a stored procedure.
   • CA transaction can be started explicitly by executing a BEGIN WORK statement and end explicitly by executing a COMMIT WORK statement.
   • DA transaction can be started explicitly by executing a BEGIN TRANSACTION statement and end explicitly by executing an END TRANSACTION statement.
   • EExplicit transactions should contain only DML statements and query statements. All DDL statements implicitly commit active transactions.

   Show answer

   Answer: CE

   References

   • Snowflake documentation

   Next question

7. Question 87 · 193 in bank

   Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A. What is required to allow data sharing between these two companies?

   • ACreate a pipeline to write shared data to a cloud storage location in the target cloud provider.
   • BEnsure that all views are persisted, as views cannot be shared across cloud platforms.
   • CSetup data replication to the region and cloud platform where the consumer resides.
   • DCompany A and Company B must agree to use a single cloud platform: Data sharing is only possible if the companies share the same cloud provider.

   Show answer

   Answer: C

   Explanation

   Answer A. It cannot be answer C, because the companies would need to be in the "within the same organization", according to Snowflake documentation for replication.

   Source: Adapted from community discussion — cloud_ranger

   Next question

8. Question 88 · 193 in bank

   A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps: 1. Deployment of Snowflake accounts on two different cloud providers. 2. Selection of cloud provider regions that are geographically far apart. 3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts. 4. Implementation of Snowflake client redirect. What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

   • AConnect the applications using the - URL. Use the Business Critical Snowflake edition.
   • BConnect the applications using the - URL. Use the Virtual Private Snowflake (VPS) edition.
   • CConnect the applications using the - URL. Use the Enterprise Snowflake edition.
   • DConnect the applications using the - URL. Use the Business Critical Snowflake edition.

   Show answer

   Answer: A

   Next question

9. Question 89 · 193 in bank

   A company's Architect needs to find an efficient way to get data from an external partner, who is also a Snowflake user. The current solution is based on daily JSON extracts that are placed on an FTP server and uploaded to Snowflake manually. The files are changed several times each month, and the ingestion process needs to be adapted to accommodate these changes. What would be the MOST efficient solution?

   • AAsk the partner to create a share and add the company's account.
   • BAsk the partner to use the data lake export feature and place the data into cloud storage where Snowflake can natively ingest it (schema-on-read).
   • CKeep the current structure but request that the partner stop changing files, instead only appending new files.
   • DAsk the partner to set up a Snowflake reader account and use that account to get the data for ingestion.

   Show answer

   Answer: A

   Explanation

   json is prepared from some table(tables) and extracts to FTP. they can create a share with secure view which will contain all data with logic in place

   Source: Adapted from community discussion — AleksM

   Next question

10. Question 90 · 193 in bank

    Select 2

    Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Choose two.)

    • ASnowflake cannot handle the joins implied in a 3NF data model.
    • BThe Architect wants to remove data duplication from the data stored in Snowflake.
    • CThe Architect is designing a landing zone to receive raw data into Snowflake.
    • DThe BI tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.
    • EThe Architect wants to present a simple flattened single view of the data to a particular group of end users.

    Show answer

    Answer: DE

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

ARA-C01 practice, question 81. 193 questions available.