ARA-C01 practice questions 181–190

1. Question 181 · 193 in bank

   Select 2

   A global company with operations in North America, Europe, and Asia needs to secure its Snowflake environment, focus on data privacy, secure connectivity, and access control. The company uses AWS as their primary cloud provider and needs to ensure that all data transfers are secure and comply with regional regulations. How can these requirements be met? (Choose two).

   • AConfigure SAML 2.0 to authenticate users in the Snowflake environment.
   • BConfigure detailed logging and monitoring of all network traffic to and from Snowflake using Snowflake’s native capabilities.
   • CUse public endpoints with SSL encryption to secure data transfers between Snowflake and the company’s AWS infrastructure.
   • DConfigure network policies to restrict access to Snowflake based on IP ranges corresponding to corporate offices.
   • EUse AWS PrivateLink to establish private connectivity between the company’s Snowflake account and its AWS VPCs.

   Show answer

   Answer: DE

   Next question

2. Question 182 · 193 in bank

   An Architect is designing a solution that includes using dynamic tables to transform data, with a maximum target lag of five minutes behind any updates to the base table. The base table contains a large data set against which there are frequent small updates. Queries against the data set contain only basic expressions. Which setting will OPTIMIZE the dynamic table performance?

   • AUse the REFRESH_MODE = AUTO setting to have the system select the optimal refresh mode based on performance.
   • BUse the REFRESH_MODE = INCREMENTAL setting to process updated data after each refresh execution.
   • CUse the REFRESH_MODE = FULL setting to reprocess the complete dataset during every refresh.
   • DUse the REFRESH_MODE = FULL for all refreshes.

   Show answer

   Answer: B

   Next question

3. Question 183 · 193 in bank

   A company is migrating to Snowflake. Production and non-production data cannot be in the same account. Which account design and lifecycle management plan will meet this requirement?

   • A1. Create one Snowflake account. 2. Use Dynamic Data Masking and row access policies in a Production environment for performance and cost optimization. 3. Create three databases, Development, Test, and Production. 4. Use one role and one warehouse for all three databases for efficient warehouse caching.
   • B1. Create two Snowflake accounts, Production and Non-Production. 2. Use the Non-Production account for development and testing. 3. When development is complete clone the databases for testing and execute workloads on top of the cloned data within the Non-Production account. 4. When testing is complete push the code to the Production account using version control.
   • C1. Create three Snowflake accounts, Production, Test, and Development. 2. When development is complete, clone the data from the Development account to the Test account. 3. When testing is complete push the code and data to the Production account, using version control.
   • D1. Create three Snowflake accounts, Production, Test, and Development. 2. When development is complete, unload the data from the Development account and load all the data into the Test account using the COPY INTO command. 3. When testing is complete unload the data from the Test account and load it into the Production account using the COPY INTO command.

   Show answer

   Answer: B

   Next question

4. Question 184 · 193 in bank

   A company wants to configure the Client Redirect feature on their account to ensure business continuity during failover events. How should an Architect accomplish this?

   • AEnable the Snowflake users to use another URL to login into a Snowflake account where the replicated objects are available.
   • BRedirect the users’ workloads and queries of the impacted account between the available accounts in the company.
   • CEnable access to the data by redirecting the connection to an available account in the closest region that is part of the company.
   • DRedirect the client connections to another Snowflake account in a different region where a secondary account will act as the primary account.

   Show answer

   Answer: D

   Next question

5. Question 185 · 193 in bank

   Select 2

   Which requirements indicate that a multi-Snowflake account strategy should be used? (Choose two.)

   • AA requirement to use different Snowflake editions
   • BA requirement for easy object promotion using zero-copy cloning
   • CA requirement to use Snowflake on a single cloud provider or in a single region
   • DA requirement to minimize the complexity of changing database names for environments during deployment
   • EA requirement to use Role-Based Access Control (RBAC) to govern DevOps processes across environments

   Show answer

   Answer: AE

   Next question

6. Question 186 · 193 in bank

   PDF files are being ingested into a Snowflake environment. The files will be staged and processed into tables later. The data will be shared directly using software links to the PDF files, with server-side encryption enabled. How should these PDF files be ingested while creating a catalog of staged files, using server-side encryption?

   • ACreate a Python User-Defined Function (UDF) to process the PDF files into tables.
   • BCREATE STAGE invoices_pdf_stage - ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE');
   • CCREATE STAGE invoices_pdf_stage - ENCRYPTION = (TYPE = 'SNOWFLAKE_SSE') DIRECTORY = ( ENABLE = true );
   • DCREATE STAGE my_stage URL = 's3://bucketname/PDFs/' CREDENTIALS = (AWS_KEY_ID = 'xxyyzz' AWS_SECRET_KEY = 'zzyyxx');

   Show answer

   Answer: C

   Next question

7. Question 187 · 193 in bank

   Select 2

   An Architect has selected the Snowflake Connector for Python to integrate and manipulate Snowflake data using Python to handle large data sets and complex analyses. Which features should the Architect consider in terms of query execution and data type conversion? (Choose two.)

   • AThe large queries will require conn.cursor() to execute.
   • BThe Connector supports asynchronous and synchronous queries.
   • CThe Connector converts NUMBER data types to DECIMAL by default.
   • DThe Connector converts Snowflake data types to native Python data types by default.
   • EThe Connector converts data types to STRING by default.

   Show answer

   Answer: BD

   Next question

8. Question 188 · 193 in bank

   Company A acquired Company B. Company B has clients that are direct competitors of Company A. Both companies need to continue to run independent data operations. An Architect has been asked to investigate if a shared Snowflake infrastructure is feasible. Following Snowflake recommendations, which account design strategy would support this workload?

   • AUse a single Snowflake account with separate databases, using Role-Based Access Control to isolate Company A’s data from Company B’s data.
   • BUse a single Snowflake account with separate virtual warehouses, using data masking policies for client-level data access.
   • CUse a separate Snowflake account for each company, using Secure Data Sharing to exchange data as needed.
   • DUse one primary account for Company A under a Snowflake Organization, and use a secondary replicated account for Company B.

   Show answer

   Answer: C

   Next question

9. Question 189 · 193 in bank

   A company uses Snowflake to store and analyze their customer data. The company has a strict regulatory requirement to protect Personally Identifiable Information (PII). What should an Architect do to meet this requirement?

   • AUse row-level security to mask PII data.
   • BUse tag-based masking policies for columns that contain PII data.
   • CCreate secure views for the PII data and grant access to the views as needed.
   • DCreate separate tables for columns containing PII and those that do not; grant access as needed

   Show answer

   Answer: B

   Next question

10. Question 190 · 193 in bank

    An Architect has a table called leader_follower that has 1 column named JSON and has 1 row in it with the following structure:

    

    Which query will produce the following results?

    

    • A//IMG//
    • B//IMG//
    • C//IMG//
    • D//IMG//

    Show answer

    Answer: B

    Next question

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

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