2024年最新のSnowflake ARA-C01試験問題には217問があります [Q22-Q41]

2024年最新のSnowflake ARA-C01試験問題には217問があります

無料で使えるARA-C01別格な問題集をダウンロード2024年01月13日に更新された217問があります

質問 # 22
Which of the below objects cannot be replicated?

A. Resource Monitors
B. Databases
C. Warehouses
D. Users
E. Roles
F. Shares

正解：A、C、D、E、F

質問 # 23
You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days.
What will be the impact on the table data?

A. Changes will impact only new data
B. Any data that is 10 days older and moved to fail-safe will not have any impact
C. Any data which has not reached the 10 days time-travel period, will now have time-travel extended for 20 days

正解：B、C

質問 # 24
You have a view.
How will you list all the object references of the view?

A. GET_VIEW_REFERENCES
B. GET_OBJECT_REFERENCES
C. GET_VIEW_METADATA

正解：B

質問 # 25
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

A. GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
B. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
C. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

正解：A

質問 # 26
In this scenarios, files are constantly getting ingested in an external stage, the files are between 1 and 4 MB. You want to load the data immediately into a table without any human intervention.
What will you use?

A. Use Snowpipe rest APIs
B. Use Snowpipe with auto ingest
C. Create a materialize view on the external stage

正解：B

質問 # 27
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

A. After the ETL run, execute the identical queries so that they remain in the result cache
B. After the ETL run, copy the tables to another schema for the business users to query
C. After the ETL run, resize the warehouse to a larger warehouse

正解：A

質問 # 28
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice

A. TRUE
B. FALSE

正解：B

質問 # 29
You have created a table as below
CREATE TABLE TEST_01 (NAME STRING(10));
What data type SNOWFLAKE will assign to column NAME?

A. VARCHAR
B. LONGCHAR
C. STRING

正解：A

質問 # 30
A company has a Snowflake account named ACCOUNTA in AWS us-east-1 region. The company stores its marketing data in a Snowflake database named MARKET_DB. One of the company's business partners has an account named PARTNERB in Azure East US 2 region. For marketing purposes the company has agreed to share the database MARKET_DB with the partner account.
Which of the following steps MUST be performed for the account PARTNERB to consume data from the MARKET_DB database?

A. Create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then replicate this database to the partner's account PARTNERB.
B. From account ACCOUNTA create a share of database MARKET_DB, and create a new database out of this share locally in AWS us-east-1 region. Then make this database the provider and share it with the PARTNERB account.
C. Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA create a share of database MARKET_DB, create a new database out of this share locally in AWS us-east-1 region, and replicate this new database to AZABC123 account. Then set up data sharing to the PARTNERB account.
D. Create a new account (called AZABC123) in Azure East US 2 region. From account ACCOUNTA replicate the database MARKET_DB to AZABC123 and from this account set up the data sharing to the PARTNERB account.

正解：D

質問 # 31
SNOWPIPE_AUTO_INGEST is supported for external stages only

A. FALSE
B. TRUE

正解：B

質問 # 32
Following objects can be cloned in snowflake

A. Permanent table
B. Internal stages
C. Transient table
D. Temporary table
E. External tables

正解：A、C、D

質問 # 33
While loading data into a table from stage, which are the valid copyOptions

A. ERROR_STATEMENT
B. ABORT_STATEMENT
C. SKIP_FILE_<NUM>
D. SKIP_FILE_<NUM>%
E. CONTINUE
F. SKIP_FILE

正解：B、C、D、E、F

質問 # 34
Which copy options are not supported by CREATE PIPE...AS COPY FROM command?

A. FILES = ( 'file_name1' [ , 'file_name2', ... ] )
B. VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
C. ON_ERROR = ABORT_STATEMENT
D. MATCH_BY_COLUMN_NAME = CASE_SENSITIVE | CASE_INSENSITIVE | NONE
E. FORCE = TRUE | FALSE

正解：A、B、C、D、E

質問 # 35
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.

A. FALSE
B. TRUE

正解：B

質問 # 36
Which of the below query will you run to get the approximate number of distinct values in a table?

A. select count_distinct(column1 approx) from table1;
B. select approx_count(column1) from table1;
C. select approx_count_distinct(column1) from table1;

正解：C

質問 # 37
You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.
Which mode will you use for the warehouse?

A. Minimized
B. Auto-Scale
C. Maximized

正解：C

質問 # 38
For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service.
What is this object called?

A. External job
B. External Script
C. External function
D. External procedure

正解：C

質問 # 39
You have a need to make external file data available to your users with the lowest latency. The files are on an external stage in AWS.
What feature of Snowflake is the most appropriate to use

A. Secure View
B. SnowPipe
C. Materialized View

正解：B

質問 # 40
With default settings, how long will a query run on snowflake

A. Snowflake will cancel the query if the warehouse runs out of memory and hard disk storage
B. Snowflake will cancel the query if it runs more than 48 hours
C. Snowflake will cancel the query if the warehouse runs out of memory
D. Snowflake will cancel the query if it runs more than 24 hours

正解：B

質問 # 41
......

Snowflake ARA-C01試験実践テスト問題：https://www.jpntest.com/shiken/ARA-C01-mondaishu