최신 ARA-C01 무료덤프 - Snowflake SnowPro Advanced Architect Certification

문제1

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?

A. Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B. Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

C. Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.

D. Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제2

A retailer's enterprise data organization is exploring the use of Data Vault 2.0 to model its data lake solution. A Snowflake Architect has been asked to provide recommendations for using Data Vault 2.0 on Snowflake.
What should the Architect tell the data organization? (Select TWO).

A. There are performance challenges when using Snowflake to load multiple Point-in-Time (PIT) tables in parallel from a single join query from the data vault.

B. Change data capture can be performed using the Data Vault 2.0 HASH_DIFF concept.

C. Using the multi-table insert feature, multiple Point-in-Time (PIT) tables can be loaded sequentially from a single join query from the data vault.

D. Change data capture can be performed using the Data Vault 2.0 HASH_DELTA concept.

E. Using the multi-table insert feature in Snowflake, multiple Point-in-Time (PIT) tables can be loaded in parallel from a single join query from the data vault.

정답: B,E

설명: (DumpTOP 회원만 볼 수 있음)

문제3

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?

A. Deploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views.

B. Deploy a Private Data Exchange in combination with data shares for the European accounts.

C. Migrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange.

D. Deploy a Private Data Exchange and use replication to allow European data shares in the Exchange.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제4

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy.
Which requirements will be addressed with this approach? (Choose two.)

A. There needs to be fewer objects per tenant.

B. Storage costs must be optimized.

C. Security and Role-Based Access Control (RBAC) policies must be simple to configure.

D. Tenant data shape may be unique per tenant.

E. Compute costs must be optimized.

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제5

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

A. GRANT ROLE NEW_ROLE TO USER USER_01;
GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

B. GRANT ROLE NEW_ROLE TO USER_01;
GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

C. GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

D. GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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.)

A. Create a table stream on the shared table.

B. Grant modify permissions on the share.

C. Create a table from the shared database.

D. Clone a table from a share.

E. Create additional views inside the shared database.

정답: D,E

설명: (DumpTOP 회원만 볼 수 있음)

문제7

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

A. FAIL

B. SKIP_FILE

C. ABORT_STATEMENT

D. CONTINUE

정답: B,C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

A. The CHANGES clause

B. The MERGE command

C. A STREAM object

D. The UPSERT command

E. The CHANGE_DATA_CAPTURE command

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

A. lnmon/3NF

B. Data vault

C. Data lake

D. Bayesian hierarchical model

E. Dimensional/Kimball

F. Graph model

정답: A,B,E

설명: (DumpTOP 회원만 볼 수 있음)

문제10

A user is executing the following command sequentially within a timeframe of 10 minutes from start to finish:

What would be the output of this query?

A. The offset -> is not a valid clause in the clone operation.

B. Time Travel data is not available for table T_SALES.

C. Table T_SALES_CLONE successfully created.

D. Syntax error line 1 at position 58 unexpected 'at'.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

최신 ARA-C01 무료덤프 - Snowflake SnowPro Advanced Architect Certification

우리와 연락하기

유용한 링크

최신 업데이트