ARA-C01 practice questions 191–193

1. Question 191 · 193 in bank

   Select 2

   A company has a call center that processes sensitive Personally Identifiable Information (PII) and Protected Health Information (PHI). The company wants to implement the following security features: • Object owners and users with privileged roles should have access to columns that contain sensitive data. • Data loaded in pre-tokenized form should be de-tokenized at query time. What should be used to meet these requirements? (Choose two.)

   • AObject tagging
   • BMaterialized views
   • CExternal tokenization
   • DDynamic Data Masking
   • ERole-Based Access Control (RBAC)

   Show answer

   Answer: CD

   Next question

2. Question 192 · 193 in bank

   An Architect wants to alter a virtual warehouse for horizontal scaling, but did not find where to configure minimum and maximum clusters in the interface even though they have an ACCOUNTADMIN role. What is MOST likely the issue?

   • AThey do not have the necessary CREATE WAREHOUSE privilege.
   • BThey are using an incorrect SQL command to alter the warehouse clusters.
   • CThey are using Standard Snowflake edition where multi-cluster is not available.
   • DThey need to create a ticket with Snowflake Support to fix the issue.

   Show answer

   Answer: C

   Next question

3. Question 193 · 193 in bank

   A Snowflake account with three warehouses has this monitoring set up for the next 30 days: 1. Warehouse1 has resource_monitor1 set with a credit quota of 2000 2. Warehouse2 has resource_monitor2 set with a credit quota of 3000 3. Warehouse3 has resource_monitor3 set with a credit quota of 1000 At the account level resource_monitor4 is set with a quota of 5000 for the next 30 days. What will occur when Warehouse1 is at 1000, Warehouse2 is at 3000 and Warehouse3 is at 1000?

   • AWarehouse2 will suspend.
   • BWarehouse2 and Warehouse3 will suspend.
   • CWarehouse1, Warehouse2, and Warehouse3 will suspend.
   • DNone of the warehouses will suspend until all three reach the quota of 5000.

   Show answer

   Answer: C

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

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