ARA-C01 practice questions 51–60

1. Question 51 · 193 in bank

   A company has several sites in different regions from which the company wants to ingest data. Which of the following will enable this type of data ingestion?

   • AThe company must have a Snowflake account in each cloud region to be able to ingest data to that account.
   • BThe company must replicate data between Snowflake accounts.
   • CThe company should provision a reader account to each site and ingest the data through the reader accounts.
   • DThe company should use a storage integration for the external stage.

   Show answer

   Answer: D

   Explanation

   D would seem to be the correct answer because the question is about data that has not already been ingested into Snowflake. Consequently cross region replication is not relevant.

   Source: Adapted from community discussion — DataKelpie

   Next question

2. Question 52 · 193 in bank

   What Snowflake features should be leveraged when modeling using Data Vault?

   • ASnowflake’s support of multi-table inserts into the data model’s Data Vault tables
   • BData needs to be pre-partitioned to obtain a superior data access performance
   • CScaling up the virtual warehouses will support parallel processing of new source loads
   • DSnowflake’s ability to hash keys so that hash key joins can run faster than integer joins

   Show answer

   Answer: A

   Explanation

   Answer is A, C is wrong cause scaling up improves query performance, it should be scaling out as data vault require high concurrent query execution

   Source: Adapted from community discussion — chiiiik

   Next question

3. Question 53 · 193 in bank

   A company’s client application supports multiple authentication methods, and is using Okta. What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

   • A1. OAuth (either Snowflake OAuth or External OAuth) 2. External browser 3. Okta native authentication 4. Key Pair Authentication, mostly used for service account users 5. Password
   • B1. External browser, SSO 2. Key Pair Authentication, mostly used for development environment users 3. Okta native authentication 4. OAuth (ether Snowflake OAuth or External OAuth) 5. Password
   • C1. Okta native authentication 2. Key Pair Authentication, mostly used for production environment users 3. Password 4. OAuth (either Snowflake OAuth or External OAuth) 5. External browser, SSO
   • D1. Password 2. Key Pair Authentication, mostly used for production environment users 3. Okta native authentication 4. OAuth (either Snowflake OAuth or External OAuth) 5. External browser, SSO

   Show answer

   Answer: A

   Next question

4. Question 54 · 193 in bank

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

   • AAccount --> Database --> Schema --> Warehouse
   • BOrganization --> Account --> Database --> Schema --> Stage
   • CAccount --> Schema > Table --> Stage
   • DOrganization --> Account --> Stage --> Table --> View

   Show answer

   Answer: B

   Next question

5. Question 55 · 193 in bank

   A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors. The company’s Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions. According to Snowflake recommended best practice, how should these requirements be met?

   • AMigrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange.
   • BDeploy a Private Data Exchange in combination with data shares for the European accounts.
   • CDeploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views.
   • DDeploy a Private Data Exchange and use replication to allow European data shares in the Exchange.

   Show answer

   Answer: D

   Next question

6. Question 56 · 193 in bank

   Which of the following are characteristics of Snowflake’s parameter hierarchy?

   • ASession parameters override virtual warehouse parameters.
   • BVirtual warehouse parameters override user parameters.
   • CTable parameters override virtual warehouse parameters.
   • DSchema parameters override account parameters.

   Show answer

   Answer: D

   Explanation

   When the parameter like STATEMENT_QUEUED_TIMEOUT_IN_SECONDS is set for both a warehouse and a session, the lowest non-zero value is enforced therefore A is not correct. D is my answer

   Source: Adapted from community discussion — anikl

   References

   • Snowflake documentation

   Next question

7. Question 57 · 193 in bank

   Select 2

   A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

   • AThere needs to be fewer objects per tenant.
   • BSecurity and Role-Based Access Control (RBAC) policies must be simple to configure.
   • CCompute costs must be optimized.
   • DTenant data shape may be unique per tenant.
   • EStorage costs must be optimized.

   Show answer

   Answer: BD

   Explanation

   I think we can exclude C & E cause they are not requirements well solved by using APT, I'm not sure about A, but it seems unnecessary to use APT with few objects. Potential is A cause RBAC is not required to isolate tenant ( Refer Part Three: Evaluating Tenancy Models in https://developers.snowflake.com/wp-content/uploads/2021/05/Design-Patterns-for-Building-Multi-Tenant-Applications-on-Snowflake.pdf). And the left is D, I think it's reasonable to use APT

   Source: Adapted from community discussion — chiiiik

   Next question

8. Question 58 · 193 in bank

   An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time. The Architect then checks the schema history and sees the following: CREATED_ON|NAME|DROPPED_ON - 2021-06-02 23:00:00 | STAGING | NULL 2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00 How can cloning the STAGING schema be achieved?

   • AUndrop the STAGING schema and then rerun the CLONE statement.
   • BModify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-05-01 10:00:00');
   • CRename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.
   • DCloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.

   Show answer

   Answer: C

   Next question

9. Question 59 · 193 in bank

   Select 3

   What are purposes for creating a storage integration? (Choose three.)

   • AControl access to Snowflake data using a master encryption key that is maintained in the cloud provider’s key management service.
   • BStore a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
   • CSupport multiple external stages using one single Snowflake object.
   • DAvoid supplying credentials when creating a stage or when loading or unloading data.
   • ECreate private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
   • FManage credentials from multiple cloud providers in one single Snowflake object.

   Show answer

   Answer: BCD

   Explanation

   B,C,D https://docs.snowflake.com/en/sql-reference/sql/create-storage-integration 1 - A storage integration is a Snowflake object that stores a generated identity and access management (IAM) entity for your external cloud storage. 2 - This option allows users to avoid supplying credentials when creating stages or when loading or unloading data. 3 - A single storage integration can support multiple external stages. The URL in the stage definition must align with the storage location specified for the STORAGE_ALLOWED_LOCATIONS parameter.

   Source: Adapted from community discussion — OscarWest2023

   References

   • Snowflake documentation

   Next question

10. Question 60 · 193 in bank

    Select 3

    A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

    • AUse, at minimum, the Business Critical edition of Snowflake.
    • BCreate Dynamic Data Masking policies and apply them to columns that contain PHI.
    • CUse the Internal Tokenization feature to obfuscate sensitive data.
    • DUse the External Tokenization feature to obfuscate sensitive data.
    • ERewrite SQL queries to eliminate projections of PHI data based on current_role().
    • FAvoid sharing data with partner organizations.

    Show answer

    Answer: ABD

    Explanation

    A,B,D. You need External Tokenization and Dynamic data masking to meet the compliance and privacy requirements. While bot of those features are available within Enterprise Edition, Snowflakes documentation specifies to use Business critical where you have PHI and other privacy requirements. Business Critical Edition, offers even higher levels of data protection to support the needs of organizations with extremely sensitive data, particularly PHI data that must comply with HIPAA and HITRUST CSF regulations. It includes all the features and services of Enterprise Edition, with the addition of enhanced security and data protection. In addition, database failover/failback adds support for business continuity and disaster recovery. https://docs.snowflake.com/en/user-guide/intro-editions

    Source: Adapted from community discussion — OscarWest2023

    References

    • Snowflake documentation

    Next question

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

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