Snowflake ARA-R01 SnowPro Advanced: Architect Recertification Exam Exam Practice Test Questions

• Question 1

  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?

  • Create a share.
  • Add objects to the share.
  • Add a consumer account to the share for the vendor to access. B.
  • Create a share.
  • Create a reader account for the vendor to use.
  • Add the reader account to the share. C.
  • Create a new role called db_share.
  • Grant the db_share role privileges to read data from the company database and schema.
  • Create a user for the vendor.
  • Grant the ds_share role to the vendor's users. D.
  • Promote an existing database in the company's local account to primary.
  • Replicate the database to Snowflake on Azure in the West-Europe region.
  • Create a share and add objects to the share.
  • Add a consumer account to the share for the vendor to access.

  Show Answer Answer: A Next

• Question 2

  An Architect is designing a pipeline to stream event data into Snowflake using the Snowflake Kafka connector. The Architect’s highest priority is to configure the connector to stream data in the MOST cost-effective manner.Which of the following is recommended for optimizing the cost associated with the Snowflake Kafka connector?

  • Utilize a higher Buffer.flush.time in the connector configuration.
  • Utilize a higher Buffer.size.bytes in the connector configuration.
  • Utilize a lower Buffer.size.bytes in the connector configuration.
  • Utilize a lower Buffer.count.records in the connector configuration.

  Show Answer Answer: A Next

• Question 3

  The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.What will happen to the consumer account if a new table (table_6) is added to the provider schema?

  • The consumer role will automatically see the new table and no additional grants are needed.
  • The consumer role will see the table only after this grant is given on the consumer side: grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;
  • The consumer role will see the table only after this grant is given on the provider side: use role accountadmin;Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;
  • The consumer role will see the table only after this grant is given on the provider side: use role accountadmin;
  • Grant usage on database EDW to share PSHARE_EDW_4TEST ;
  • Grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
  • Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

  Show Answer Answer: D Next

• Question 4

  A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.What can be done to improve performance?

  • Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur.
  • Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur.
  • Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data.
  • Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used.

  Show Answer Answer: A Next

• Question 5

  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?

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

  Show Answer Answer: D Next