ARA-C01試験無料問題集「Snowflake SnowPro Advanced Architect Certification 認定」

A. Rewrite SQL queries to eliminate projections of PHI data based on current_role().

B. Avoid sharing data with partner organizations.

C. Create Dynamic Data Masking policies and apply them to columns that contain PHI.

D. Use the External Tokenization feature to obfuscate sensitive data.

E. Use, at minimum, the Business Critical edition of Snowflake.

F. Use the Internal Tokenization feature to obfuscate sensitive data.

A. The Connector creates and manages its own stage, file format, and pipe objects.

B. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

C. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.

D. The Connector only works in Snowflake regions that use AWS infrastructure.

A. The staging tables are of the TRANSIENT type.

B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.

C. The staging schema has not been setup for MANAGED ACCESS.

D. The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

E. The tables exceed the 1 TB limit for data recovery.

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

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 ROLE NEW_ROLE TO USER USER_01;GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

A. The objects that the tasks reference are not fully qualified.

B. Cloned tasks are suspended by default and must be manually resumed.

C. The Architect has insufficient privileges to alter tasks on the cloned database.

D. Tasks cannot be cloned.

A. The company must replicate data between Snowflake accounts.

B. The company should provision a reader account to each site and ingest the data through the reader accounts.

C. The company must have a Snowflake account in each cloud region to be able to ingest data to that account.

D. The company should use a storage integration for the external stage.

A. Create secure views for PII data and grant access as needed.

B. Use tag-based masking policies for columns containing PII.

C. Use row-level security to mask PII data.

D. Separate PII into different tables and grant access as needed.

A. 

B. 

C. 

D. 

E. 

A. Call insertReport every 8 minutes for a 10-minute time range.

B. Call loadHistoryScan every 10 minutes for a 15-minutes range.

C. Call loadHistoryScan every minute for the maximum time range.

D. Call insertReport every 20 minutes, fetching the last 10,000 entries.

A. 1. Ask the customer to create a new Snowflake account in Azure EAST US 2 (Virginia)2. Create a share and add the database privileges to the share3. Alter the share and add the customer's Snowflake account to the share

B. 1. Create a reader account in Azure East US 2 (Virginia)2. Create a share and add the database privileges to the share3. Add the reader account to the share4. Share the reader account's URL and credentials with the customer

C. 1. Create a new Snowflake account in Azure East US 2 (Virginia)2. Set up replication between AWS us- west-2 (Oregon) and Azure East US 2 (Virginia) for the database objects to be shared3. Create a share and add the database privileges to the share4. Alter the share and add the customer's Snowflake account to the share

D. 1. Create a share and add the database privileges to the share2. Create a new listing on the Snowflake Marketplace3. Alter the listing and add the share4. Instruct the customer to subscribe to the listing on the Snowflake Marketplace

A. Changing the name of the organization

B. Creating an account

C. Viewing a list of organization accounts

D. Changing the name of an account

E. Deleting an account

F. Enabling the replication of a database