ARA-C01 practice questions 141–150

1. Question 141 · 193 in bank

   A company needs to adopt a data modeling technique that fits this business model: 1. A virtual data warehouse is needed to support data analytics 2. Data comes from diverse sources 3. Data has frequent structural changes 4. Need the ability to audit each structural change as it happens at the source Which modeling technique will meet the company’s requirements?

   • AData Vault modeling
   • BDimensional data modeling
   • CStar schema modeling
   • DSnowflake schema modeling

   Show answer

   Answer: A

   Next question

2. Question 142 · 193 in bank

   A global company needs to securely share its sales and inventory data with a vendor using a Snowflake account. The company has its Snowflake account in the AWS eu-west 2 Europe (London) region. The vendor’s Snowflake account is on the Azure platform in the West Europe region. How should the company’s Architect configure the data share?

   • A1. Create a share. 2. Add objects to the share. 3. Add a consumer account to the share for the vendor to access.
   • B1. Create a share. 2. Create a reader account for the vendor to use. 3. Add the reader account to the share.
   • C1. Create a new role called DB_SHARE. 2. Grant the DB_SHARE role privileges to read data from the company database and schema. 3. Create a user for the vendor. 4. Grant the DB_SHARE role to the vendor’s users.
   • D1. Promote an existing database in the company’s local account to primary. 2. Replicate the database to Snowflake on Azure in the West-Europe region. 3. Create a share and add objects to the share. 4. Add a consumer account to the share for the vendor to access.

   Show answer

   Answer: D

   Next question

3. Question 143 · 193 in bank

   A company’s management has requested insights concerning their Snowflake usage. An Architect needs to quickly build a reporting framework for a web application which stores its data in JSON format. How can this requirement be met with the LEAST operational overhead?

   • ADefine a schema for the data before it is loaded from the application, so that it is loaded in a structured way and easy to build reports on top.
   • BLoad the semi-structured data into Snowflake and after minimal transformations, query it for the reports.
   • CFor the data that only has top-level key-value pairs and no nesting, load it in semi-structured format. For more complex data, define a schema and then load it in a structured table.
   • DShare the data in the third normal form (3NF). Load the data in semi-structured format and apply transformations to normalize the data for reporting.

   Show answer

   Answer: B

   Next question

4. Question 144 · 193 in bank

   An Architect has implemented the search optimization service for a table. A user adds a new column to the table and there is a decrease in query performance. The Architect then executes the DESCRIBE SEARCH OPTIMIZATION command and finds that the newly-added column was not included in the search access path. Why did this occur?

   • AThe new column has a data type that is not supported by the search optimization service.
   • BThe new column is automatically included in the search access path, but there is a time delay before it takes effect.
   • CThe ON clause was used when enabling the search optimization service, which does not automatically include new columns.
   • DThe SEARCH OPTIMIZATION property needs to be dropped and then added back for the changes to take effect.

   Show answer

   Answer: C

   Next question

5. Question 145 · 193 in bank

   A company implemented a Snowflake design solution using multiple public cloud services. An AWS Lambda function is invoked multiple times each day. The company has implemented Multi-Factor Authentication (MFA) based on user authentication. For machine-to-machine authentication, user names and passwords are used in many cases. The company wants a solution that will MINIMIZE interruptions to the production environment, security implementation, and operation costs, while protecting the Snowflake account from common vulnerabilities. How can these requirements be met?

   • AImplement a network policy on the account, using an allowlist for necessary CIDR ranges from the public cloud services.
   • BImplement key pair authentication and auto key rotation for authentication.
   • CImplement private connectivity on the Snowflake account and surrounding cloud services, restricting Snowflake access to private traffic only.
   • DUse a cloud provider’s secrets management service to protect passwords, and only supply the passwords at runtime.

   Show answer

   Answer: B

   Next question

6. Question 146 · 193 in bank

   Select 2

   A table, contacts_data, is created and data is inserted into it: create table contacts_data (c object); Insert into contacts_data - select parse_json (' { "customer”: { "address": "509 Kings Hwy, Comptche, Missouri, 4848", "phone": "+1 (999) 407-2274", "email": "[email protected]", "company": "SNOWFLAKE", "name": { "last": "Person", "first": "Snow" }, "_id": "5730864df388fld653e37e6f" } } '); Which queries will retrieve the first name value as Snow? (Choose two.)

   • Aselect o[customer][name][first]::string as first_name from contacts_data;
   • Bselect o['customer']['name']['first']::string as first_name from contacts_data;
   • Cselect o:['customer']:['name']:['first']::string as first_name from contacts_data;
   • Dselect 0:Customer.Name.First::string as first_name from contacts_data;
   • Eselect 0:customer.name.first::string as first_name from contacts_data;

   Show answer

   Answer: BE

   Next question

7. Question 147 · 193 in bank

   Select 2

   How does Snowflake handle replication for source and target accounts that have Tri-Secret Secure enabled? (Choose two.)

   • AEach replication job will use the same key.
   • BWhen replicating between accounts that have Tri-Secret Secure enabled, the same key is required for the source and target accounts.
   • CWhen replicating between accounts that have Tri-Secret Secure enabled, the same key is not required for the source and target accounts.
   • DTri-Secret Secure requires key-pair authentication for replication.
   • ESnowflake encrypts the database files in transit from the source account to the target account.

   Show answer

   Answer: CE

   Next question

8. Question 148 · 193 in bank

   Database DB1 has schema S1 which has one table, T1: DB1 --> S1 --> T1 - The retention period of DB1 is set to 10 days. The retention period of S1 is set to 20 days. The retention period of T1 is set to 30 days. The user runs the following command: Drop Database DB1; What will the Time Travel retention period be for T1?

   • A10 days
   • B20 days
   • C30 days
   • D37 days

   Show answer

   Answer: A

   Next question

9. Question 149 · 193 in bank

   Select 2

   What occurs when unloading data from Snowflake? (Choose two.)

   • AAll data files unloaded to an external stage are automatically encrypted using 128-bit keys.
   • BAll data files unloaded to an internal stage are automatically encrypted using 128-bit keys.
   • CTarget cloud storage can only be in the same cloud and region as Snowflake.
   • DOutput files are encoded using UTF-8.
   • EAll data files are uncompressed by default.

   Show answer

   Answer: BD

   Next question

10. Question 150 · 193 in bank

    A company that is in one region wants to share data with two different consumers who are both based in a second region. How can this be accomplished with the LEAST amount of data duplication?

    • AReplicate one copy of the data to the second region, and share it with the two data consumers.
    • BReplicate two copies of the data to the second region, and share each one respectively with the two consumers.
    • CReplicate two copies of the data to the second region, but only share one of the copies with the two data consumers.
    • DCreate a direct share from the first region to the second region, and provide access to both data consumers.

    Show answer

    Answer: A

    Next question

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

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