ARA-C01無料問題集「Snowflake SnowPro Advanced Architect Certification」

質問 1

A company needs to have the following features available in its Snowflake account:
1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)
In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

（A）Standard

（B）Virtual Private Snowflake (VPS)

（C）Business Critical

（D）Enterprise

正解：C 解答を投票する

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

質問 2

A data platform team creates two multi-cluster virtual warehouses with the AUTO_SUSPEND value set to NULL on one. and '0' on the other. What would be the execution behavior of these virtual warehouses?

（A）Setting a '0' or NULL value means the warehouses will suspend after the default of 600 seconds.

（B）Setting a '0' or NULL value means the warehouses will never suspend.

（C）Setting a '0' value means the warehouses will suspend immediately, and NULL means the warehouses will never suspend.

（D）Setting a '0' or NULL value means the warehouses will suspend immediately.

正解：C 解答を投票する

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

質問 3

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_IDLIKE
'%PHPP%';

（C）select*fromDEMO_DB.DEMO_SCH.CUSTOMER_ADDRESSWhereCA_ADDRESS_IDNOT LIKE
'%AAAAAAAAPHPPL%';

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

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

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

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

質問 4

A company's client application supports multiple authentication methods, and is using Okta.
What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

（A）1) External browser, SSO
2) Key Pair Authentication, mostly used for development environment users
3) Okta native authentication
4) OAuth (ether Snowflake OAuth or External OAuth)
5) Password

（B）1) Okta native authentication
2) Key Pair Authentication, mostly used for production environment users
3) Password
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO

（C）1) OAuth (either Snowflake OAuth or External OAuth)
2) External browser
3) Okta native authentication
4) Key Pair Authentication, mostly used for service account users
5) Password

（D）1) Password
2) Key Pair Authentication, mostly used for production environment users
3) Okta native authentication
4) OAuth (either Snowflake OAuth or External OAuth)
5) External browser, SSO

正解：C 解答を投票する

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

質問 5

An Architect is designing a solution that will be used to process changed records in an orders table.
Newly-inserted orders must be loaded into the f_orders fact table, which will aggregate all the orders by multiple dimensions (time, region, channel, etc.). Existing orders can be updated by the sales department within 30 days after the order creation. In case of an order update, the solution must perform two actions:
1. Update the order in the f_0RDERS fact table.
2. Load the changed order data into the special table ORDER _REPAIRS.
This table is used by the Accounting department once a month. If the order has been changed, the Accounting team needs to know the latest details and perform the necessary actions based on the data in the order_repairs table.
What data processing logic design will be the MOST performant?

（A）Useone stream and one task.

（B）Usetwo streams and two tasks.

（C）Usetwo streams and one task.

（D）Useone stream and two tasks.

正解：D 解答を投票する

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

質問 6

An Architect needs to allow a user to create a database from an inbound share.
To meet this requirement, the user's role must have which privileges? (Choose two.)

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

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

質問 7

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?

（A）The consumer role will automatically see the new table and no additional grants are needed.

（B）The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;
grant usage on schema EDW.ACCOUNTING to share PSHARE_EDW_4TEST ;
Grant select on table EDW.ACCOUNTING.Table_6 to database PSHARE_EDW_4TEST_DB ;

（C）The consumer role will see the table only after this grant is given on the consumer side:
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

（D）The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

正解：B 解答を投票する

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

質問 8

An Architect Is designing a data lake with Snowflake. The company has structured, semi-structured, and unstructured data. The company wants to save the data inside the data lake within the Snowflake system. The company is planning on sharing data among Its corporate branches using Snowflake data sharing.
What should be considered when sharing the unstructured data within Snowflake?

（A）A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with the "expiration_time" argument defined for the URL time limit.

（B）A scoped URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 24-hour time limit for the URL.

（C）A pre-signed URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with no time limit for the URL.

（D）A file URL should be used to save the unstructured data into Snowflake in order to share data over secure views, with a 7-day time limit for the URL.

正解：A 解答を投票する

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

質問 9

An Architect is integrating an application that needs to read and write data to Snowflake without installing any additional software on the application server.
How can this requirement be met?

（A）Use SnowSQL.

（B）Use the Snowpipe REST API.

（C）Use the Snowflake ODBC driver.

（D）Use the Snowflake SQL REST API.

正解：D 解答を投票する

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

質問 10

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 is processing a very large dataset.

（B）The query has overly complex logic.

（C）The query is reading from remote storage.

（D）The query is queued for execution.

正解：B 解答を投票する

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

ARA-C01 無料問題集「Snowflake SnowPro Advanced Architect Certification」

弊社を連絡する

関連リンク

トップ試験