Snowflake ARA-C01 - SnowPro Advanced Architect Certification

Why might a Snowflake Architect use a star schema model rather than a 3NF model when designing a data architecture to run in Snowflake? (Select TWO).

• A. The Architect is designing a landing zone to receive raw data into Snowflake.
• B. Snowflake cannot handle the joins implied in a 3NF data model.
• C. The Architect wants to present a simple flattened single view of the data to a particular group of end users.
• D. The Bl tool needs a data model that allows users to summarize facts across different dimensions, or to drill down from the summaries.
• E. The Architect wants to remove data duplication from the data stored in Snowflake.

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage).
Why Is this occurring?

• A. The Snowflake timezone parameter Is different from the cloud provider's parameters causing the mismatch.
• B. The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.
• C. The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned
• D. The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.

Data is being imported and stored as JSON in a VARIANT column. Query performance was fine, but most recently, poor query performance has been reported.
What could be causing this?

• A. There were JSON nulls in the recent data imports.
• B. The recent data imports contained fewer fields than usual.
• C. There were variations in string lengths for the JSON values in the recent data imports.
• D. The order of the keys in the JSON was changed.

A new user user_01 is created within Snowflake. The following two commands are executed:
Command 1# SHOW GRANTS TO USER user_01;
Command 2# SHOW GRANTS ON USER user_01;
What inferences can be made about these commands?

• A. Command 1 defines all the grants which are given to user_01Command 2 defines which user owns user_01
• B. Command 1 defines which role owns user_01Command 2 defines all the grants which have been given to user_01
• C. Command 1 defines which user owns user_01Command 2 defines all the grants which have been given to user_01
• D. Command 1 defines all the grants which are given to user_01Command 2 defines which role owns user_01

A company is designing its serving layer for data that is in cloud storage. Multiple terabytes of the data will be used for reporting. Some data does not have a clear use case but could be useful for experimental analysis.
This experimentation data changes frequently and is sometimes wiped out and replaced completely in a few days.
The company wants to centralize access control, provide a single point of connection for the end-users, and maintain data governance.
What solution meets these requirements while MINIMIZING costs, administrative effort, and development overhead?

• A. Import the data used for reporting into a Snowflake schema with native tables. Then create views that have SELECT commands pointing to the cloud storage files for the experimentation data. Then create two different roles to match the different user personas, and grant these roles to the corresponding users.
• B. Import the data used for reporting into a Snowflake schema with native tables. Then create external tables pointing to the cloud storage folders used for the experimentation data. Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.
• C. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
  Then create a role that has access to this schema and manage access to the data through that role.
• D. Import all the data in cloud storage to be used for reporting into a Snowflake schema with native tables.
  Then create two different roles with grants to the different datasets to match the different user personas, and grant these roles to the corresponding users.