ARA-R01試験無料問題集（163題）「Snowflake SnowPro Advanced: Architect Recertification 認定」

出題：1

Which Snowflake objects can be used in a data share? (Select TWO).

解説: (GoShiken メンバーにのみ表示されます)

出題：2

An Architect needs to design a data unloading strategy for Snowflake, that will be used with the COPY INTO
<location> command.
Which configuration is valid?

A. Location of files: Google Cloud Storage
. File formats: Parquet
. File encoding: UTF-8
Compression: gzip

B. Location of files: Amazon S3
. File formats: CSV, JSON
. File encoding: Latin-1 (ISO-8859)
. Encryption: 128-bit

C. Location of files: Azure ADLS
. File formats: JSON, XML, Avro, Parquet, ORC
. Compression: bzip2
. Encryption: User-supplied key

D. Location of files: Snowflake internal location
. File formats: CSV, XML
. File encoding: UTF-8
. Encryption: 128-bit

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider. To validate Private Link connectivity, an Architect performed the following steps:
* Confirmed Private Link URLs are working by logging in with a username/password account
* Verified DNS resolution by running nslookups against Private Link URLs
* Validated connectivity using SnowCD
* Disabled public access using a network policy set to use the company's IP address range However, the following error message is received when using SSO to log into the company account:
IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)

A. Alter the Azure security integration to use the Private Link URLs.

B. Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.

C. Open a case with Snowflake Support to authorize the Private Link URLs' access to the account.

D. Update the configuration of the Azure AD SSO to use the Private Link URLs.

E. Add the IP address in the error message to the allowed list in the network policy.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.
Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)

A. COPY INTO tablea FROM @%tablea FILES = ('file5.csv');

B. COPY INTO tablea FROM @%tablea FORCE = TRUE;

C. COPY INTO tablea FROM @%tablea;

D. COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;

E. COPY INTO tablea FROM @%tablea MERGE = TRUE;

F. COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

What are characteristics of Dynamic Data Masking? (Select TWO).

A. A masking policy can be applied to the value column of an external table.

B. A masking policy that Is currently set on a table can be dropped.

C. A single masking policy can be applied to columns in different tables.

D. A masking policy can be applied to a column with the GEOGRAPHY data type.

E. The role that creates the masking policy will always see unmasked data In query results

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.
What is the reason for this?

A. The query has overly complex logic.

B. The query is queued for execution.

C. The query is processing a very large dataset.

D. The query is reading from remote storage.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Two queries are run on the customer_address table:
create or replace TABLE CUSTOMER_ADDRESS ( CA_ADDRESS_SK NUMBER(38,0),
CA_ADDRESS_ID VARCHAR(16), CA_STREET_NUMBER VARCHAR(IO) CA_STREET_NAME
VARCHAR(60), CA_STREET_TYPE VARCHAR(15), CA_SUITE_NUMBER VARCHAR(10), CA_CITY VARCHAR(60), CA_COUNTY VARCHAR(30), CA_STATE VARCHAR(2), CA_ZIP VARCHAR(10), CA_COUNTRY VARCHAR(20), CA_GMT_OFFSET NUMBER(5,2), CA_LOCATION_TYPE VARCHAR(20) ); ALTER TABLE DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS ADD SEARCH OPTIMIZATION ON SUBSTRING(CA_ADDRESS_ID); Which queries will benefit from the use of the search optimization service? (Select TWO).

A. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
'%BAAASKD%';

B. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDNOT LIKE
'%AAAAAAAAPHPPL%';

C. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where CA_ADDRESS_ID= substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,16);

D. select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDLIKE
'%PHPP%';

E. select * from DEMO_DB.DEMO_SCH.CUSTOMER_ADDRESS Where
substring(CA_ADDRESS_ID,1,8)=
substring('AAAAAAAAPHPPLBAAASKDJHASLKDJHASKJD',1,8);

正解：C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

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 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which of the following are characteristics of Snowflake's parameter hierarchy?

A. Schema parameters override account parameters.

B. Virtual warehouse parameters override user parameters.

C. Session parameters override virtual warehouse parameters.

D. Table parameters override virtual warehouse parameters.

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

A global company needs to securely share its sales and Inventory data with a vendor using a Snowflake account.
The company has its Snowflake account In the AWS eu-west 2 Europe (London) region. The vendor's Snowflake account Is on the Azure platform in the West Europe region. How should the company's Architect configure the data share?

A. 1. Create a new role called db_share.
2. Grant the db_share role privileges to read data from the company database and schema.
3. Create a user for the vendor.
4. Grant the ds_share role to the vendor's users.

B. 1. Create a share.
2. Create a reader account for the vendor to use.
3. Add the reader account to the share.

C. 1. Create a share.
2. Add objects to the share.
3. Add a consumer account to the share for the vendor to access.

D. 1. Promote an existing database in the company's local account to primary.
2. Replicate the database to Snowflake on Azure in the West-Europe region.
3. Create a share and add objects to the share.
4. Add a consumer account to the share for the vendor to access.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

ARA-R01試験無料問題集「Snowflake SnowPro Advanced: Architect Recertification 認定」