ARA-C01 practice questions 41–50

1. Question 41 · 193 in bank

   Select 2

   A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps: Confirmed Private Link URLs are working by logging in with a username/password account Verified DNS resolution by running nslookups against Private Link URLs Validated connectivity using SnowCD Disabled public access using a network policy set to use the company’s IP address range However, the following error message is received when using SSO to log into the company account: IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator. What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

   • AAlter the Azure security integration to use the Private Link URLs.
   • BAdd the IP address in the error message to the allowed list in the network policy.
   • CGenerate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
   • DUpdate the configuration of the Azure AD SSO to use the Private Link URLs.
   • EOpen a case with Snowflake Support to authorize the Private Link URLs’ access to the account.

   Show answer

   Answer: AD

   Explanation

   After changing the private links , if the SSO want to work the first step is update the security integration and other mandatory step is update the config in azure ad level sso.

   Source: Adapted from community discussion — laksnarn

   Next question

2. Question 42 · 193 in bank

   Select 2

   Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

   • AChoose columns that are frequently used in join predicates.
   • BChoose lower cardinality columns to support clustering keys and cost effectiveness.
   • CChoose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
   • DChoose cluster columns that are most actively used in selective filters.
   • EChoose cluster columns that are actively used in the GROUP BY clauses.

   Show answer

   Answer: AD

   Explanation

   https://docs.snowflake.com/en/user-guide/tables-clustering-keys Snowflake recommends prioritizing keys in the order below: Cluster columns that are most actively used in selective filters. For many fact tables involved in date-based queries (for example “WHERE invoice_date > x AND invoice date <= y”), choosing the date column is a good idea. For event tables, event type might be a good choice, if there are a large number of different event types. (If your table has only a small number of different event types, then see the comments on cardinality below before choosing an event column as a clustering key.) If there is room for additional cluster keys, then consider columns frequently used in join predicates, for example “FROM table1 JOIN table2 ON table2.column_A = table1.column_B”.

   Source: Adapted from community discussion — callipso21

   References

   • Snowflake documentation

   Next question

3. Question 43 · 193 in bank

   Which Snowflake data modeling approach is designed for BI queries?

   • A3 NF
   • BStar schema
   • CData Vault
   • DSnowflake schema

   Show answer

   Answer: C

   Next question

4. Question 44 · 193 in bank

   Select 2

   An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously. Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

   • ACOPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
   • BCOPY INTO tablea FROM @%tablea;
   • CCOPY INTO tablea FROM @%tablea FILES = ('file5.csv');
   • DCOPY INTO tablea FROM @%tablea FORCE = TRUE;
   • ECOPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
   • FCOPY INTO tablea FROM @%tablea MERGE = TRUE;

   Show answer

   Answer: BC

   Explanation

   Key point here - "ON_ERROR=SKIP_FILE". It means that file hasn't loaded. I we want to load the file we have to point it explicitly - this is C option or load all unloaded files (with file5.csv); its B option. If we use FORCE we will load again ALL data from the stage - it doesn't look as a good option.

   Source: Adapted from community discussion — serg_khar

   References

   • Snowflake documentation

   Next question

5. Question 45 · 193 in bank

   Select 2

   How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

   • AA task scheduled in a UTC-based schedule will have no issues with the time changes.
   • BTask schedules can be designed to follow specified or local time zones to accommodate the time changes.
   • CA task will move to a suspended state during the daylight savings time change.
   • DA frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
   • EA task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

   Show answer

   Answer: AE

   Explanation

   Against B: "A scheduled task runs according to the specified cron expression in the local time for a given time zone. Special care should be taken with regard to scheduling tasks for time zones that recognize daylight saving time. Tasks scheduled during specific times on days when the transition from standard time to daylight saving time (or the reverse) occurs can have unexpected behaviors."

   Source: Adapted from community discussion — starkbi

   References

   • Snowflake documentation

   Next question

6. Question 46 · 193 in bank

   An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

   • ACreate a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
   • BCreate a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
   • CCreate a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
   • DThis scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

7. Question 47 · 193 in bank

   Select 2

   A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period. What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

   • AEnable a multi-clustered virtual warehouse in maximized mode during the workload duration.
   • BSet the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
   • CIncrease the size of the virtual warehouse to size X-Large.
   • DReduce the amount of data that is being processed through this workload.
   • ESet the connection timeout to a higher value than its default.

   Show answer

   Answer: AB

   Next question

8. Question 48 · 193 in bank

   Select 2

   Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

   • ASYSTEM$CLUSTERING_INFORMATION
   • BSYSTEM$CLUSTERING_USAGE
   • CSYSTEM$CLUSTERING_DEPTH
   • DSYSTEM$CLUSTERING_KEYS
   • ESYSTEM$CLUSTERING_PERCENT

   Show answer

   Answer: AC

   References

   • Snowflake documentation

   Next question

9. Question 49 · 193 in bank

   A company has a table with that has corrupted data, named Data. The company wants to recover the data as it was 5 minutes ago using cloning and Time Travel. What command will accomplish this?

   • ACREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);
   • BCREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);
   • CCREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);
   • DCREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

   Show answer

   Answer: C

   References

   • Snowflake documentation

   Next question

10. Question 50 · 193 in bank

    Select 2

    A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

    • AClone a table from a share.
    • BGrant modify permissions on the share.
    • CCreate a table from the shared database.
    • DCreate additional views inside the shared database.
    • ECreate a table stream on the shared table.

    Show answer

    Answer: CE

    Explanation

    On the basis of this documentation, the answer is C and E https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share The reasoning is as follows: Cloning of shared databases is not supported They cannot be modified Streaming (CDC) of updates is supported

    Source: Adapted from community discussion — DataKelpie

    References

    • Snowflake documentation

    Next question

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

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