最新的Snowflake SnowPro Advanced Architect Certification - ARA-C01免費考試真題

A. ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 2;

B. ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 16;

C. ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 1;

D. ALTER WAREHOUSE snowpark_opt_wh SET MAX_CONCURRENCY_LEVEL = 8;

A.

B.

C.

D.

A. Data can be filtered by an optional WHERE clause.

B. Columns can be omitted.

C. Incoming data can be joined with other tables.

D. The ON_ERROR = ABORT_STATEMENT command can be used.

E. Columns can be reordered.

F. Type casts are supported.

A. Ask the vendor to create a Snowflake account, load the data into Snowflake and create a data share.

B. Create a Snowflake Account in the Google Cloud Platform (GCP), ingest data into this account and use data replication to move the data from GCP to Azure.

C. Copy the data from Google Cloud Storage to Azure Blob storage using external tools and load data from Blob storage to Snowflake.

D. Create an external stage on Google Cloud Storage and use the external table to load the data into Snowflake.

A. CREATE on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

B. OWNERSHIP on the named pipe, USAGE and READ on the named stage, USAGE on the target database and schema, and INSERT end SELECT on the target table

C. USAGE on the named pipe, named stage, target database, and schema, and INSERT and SELECT on the target table

D. OWNERSHIP on the named pipe, USAGE on the named stage, target database, and schema, and INSERT and SELECT on the target table

A. A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

B. A task will move to a suspended state during the daylight savings time change.

C. Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

D. A task scheduled in a UTC-based schedule will have no issues with the time changes.

E. A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

A. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least
6 minutes.

B. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.

C. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

D. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.

A. Schema-on-read

B. IDEF1X

C. Schema-on-write

D. Information schema

A. Schema-on-read

B. IDEF1X

C. Schema-on-write

D. Information schema

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

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

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

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