Snowflake ARA-C01リアルに2023年最新のブレーン問題集で模擬試験問題集
ARA-C01試験問題 リアルなARA-C01練習問題集
Snowflake ARA-C01認定試験は、気弱な人向けではありません。これは、スノーフレークアーキテクチャ、データモデリング、パフォーマンスの最適化、セキュリティ、および管理を深く理解する必要がある厳密で挑戦的な試験です。試験は、120分以内に完了する必要がある60の複数選択質問で構成されています。 ARA-C01試験の合格スコアは80％であり、試験に合格した候補者にはSnowpro Advanced Architect認定が授与されます。
質問 # 100
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. Open a case with Snowflake Support to authorize the Private Link URLs' access to the account.
- B. Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
- C. Update the configuration of the Azure AD SSO to use the Private Link URLs.
- D. Add the IP address in the error message to the allowed list in the network policy.
- E. Alter the Azure security integration to use the Private Link URLs.
正解：B、D
質問 # 101
Databases created from shares cannot be replicated
- A. TRUE
- B. FALSE
正解：A
質問 # 102
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)
- A. Avro
- B. Parquet
- C. XML
- D. JSON
- E. CSV
正解：A、D
質問 # 103
Schema owner can grant object privileges in a regular schema
- A. TRUE
- B. FALSE
正解：B
質問 # 104
Privileges granted on database objects are not replicated to a secondary database.
- A. TRUE
- B. FALSE
正解：A
質問 # 105
Let's say that you have two JSONs as below
1. {"stuId":2000, "stuName":"Amy"}
2. {"stuId":2000,"stuCourse":"Snowflake"}
How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2
- A. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
- B. with stu_demography as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
- C. with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')),
- D. SELECT CONTAINS('{"stuId":2000, "stuName":"Amy"}','{"stuId":2000,"stuCourse":"Snowflake"}');
- E. with stu_demography as (select parse_json(column1) as src, src['STUID'] as ID from values('{"stuId":2000, "stuName":"Amy"}')), stu_course as (select parse_json(column1) as src, src['stuId'] as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case when stdemo.ID in(select ID from stu_course) then 'True' else 'False' end as result from stu_demography stdemo;
正解：A、B
質問 # 106
You ran the below query and it took a long time to run
select itembarcode from checkouts where BIBNUMBER = '2213435';
The clustering information shows the below result.
What can you derive from this information
select system$clustering_information('checkouts','(BIBNUMBER)');
- A. The query is running slow because BIBNUMBER does not have an index created on it.
- B. The data is not clustered well by BIBNUMBER and it is spread across all the micro-partitions, hence to retrieve a small number of micro-partitions, the query has to scan all the partitions in the table
- C. The query is running slow because the warehouse does not have enough memory
正解：B
質問 # 107
An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group's manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?
- A. Create a stored procedure that can be run using both caller's and owner's rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- B. Create a stored procedure that runs with caller's rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- C. Create a stored procedure that runs with owner's rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- D. This scenario would actually not be possible in Snowflake - any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.
正解：D
質問 # 108
For which use cases, will you use cross-cloud and cross-region replication?
- A. Data portability and account migrations
- B. Secure data sharing across regions/cloud
- C. Business continuity and disaster recovery
- D. All of these
正解：D
質問 # 109
You have a table named customer_table. You want to create another table as customer_table_other which will be same as customer_table with respect to schema and data.
What is the best option?
- A. CREATE TABLE customer_table_other AS SELECT * FROM customer_table
- B. ALTER TABLE customer_table_other SWAP WITH customer_table
- C. CREATE TABLE customer_table_other CLONE customer_table
正解：C
質問 # 110
All multi cluster warehouses that were using the Legacy policy now use the default Standard policy
- A. TRUE
- B. FALSE
正解：A
質問 # 111
Suppose you have two databases D1 and D2. Theses databases contain data required by business analysts in your organization. Based on their functional responsibilities, entry level analysts should have read only access to D1, but access to D2 should be given to advanced analysts only.
Which option will you choose to setup the access?
Option 1:
Option 2:
Option 3:
- A. Option 3
- B. Option 1
- C. Option 2
正解：A
質問 # 112
Which command below will load data from result_scan to a table?
- A. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id()));
- B. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id());
- C. INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());
正解：A
質問 # 113
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. Materialized View
- B. Secure View
- C. SnowPipe
正解：C
質問 # 114
If a multi-cluster warehouse is resized, the new size applies to
- A. Clusters that are started after the warehouse is resized
- B. All of the above
- C. Clusters that are currently running
正解：B
質問 # 115
Secure views cannot take advantage of the internal optimizations which require access to the underlying data in the base tables for the view.
- A. TRUE
- B. FALSE
正解：A
質問 # 116
Which Snowflake data modeling approach is designed for BI queries?
- A. 3 NF
- B. Snowflake schema
- C. Star schema
- D. Data Vault
正解：B
質問 # 117
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, copy the tables to another schema for the business users to query
- B. After the ETL run, resize the warehouse to a larger warehouse
- C. After the ETL run, execute the identical queries so that they remain in the result cache
正解：C
質問 # 118
Remote service in external function can be an AWS Lambda function
- A. TRUE
- B. FALSE
正解：A
質問 # 119
A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors.
The company's Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions.
According to Snowflake recommended best practice, how should these requirements be met?
- A. Deploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views.
- B. Deploy a Private Data Exchange in combination with data shares for the European accounts.
- C. Migrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange.
- D. Deploy a Private Data Exchange and use replication to allow European data shares in the Exchange.
正解：D
質問 # 120
What are purposes for creating a storage integration? (Choose three.)
- A. Manage credentials from multiple cloud providers in one single Snowflake object.
- B. Create private VPC endpoints that allow direct, secure connectivity between VPCs without traversing the public internet.
- C. Control access to Snowflake data using a master encryption key that is maintained in the cloud provider's key management service.
- D. Avoid supplying credentials when creating a stage or when loading or unloading data.
- E. Support multiple external stages using one single Snowflake object.
- F. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
正解：D、E、F
質問 # 121
Snowflake supports the following query performance optimizing methods
- A. Caching techniques
- B. B-tree type indexes
- C. Retrieving results of previous query from cache
正解：A、C
質問 # 122
Every Snowflake table loaded by the Kafka connector has a schema consisting of two VARIANT columns.
Which are those?
- A. RECORD_METADATA
- B. RECORD_MESSAGE
- C. RECORD_CONTENT
正解：A、C
質問 # 123
......
Snowpro Advanced Architect認定試験の準備をするために、候補者は、トレーニングコース、学習ガイド、練習試験など、スノーフレークが提供するさまざまなリソースを利用できます。さらに、候補者は、SnowflakeのCloud Data Platformを扱う実践的な経験や、他のSnowflakeの専門家や建築家と協力することもできます。
厳密検証されたARA-C01試験問題集と解答で無料提供のARA-C01問題と正解付き：https://jp.fast2test.com/ARA-C01-premium-file.html
あなたを合格させるARA-C01問題集無料で最新のSnowflake練習テスト：https://drive.google.com/open?id=17a2VJRe3iYdjL46pZor1ZlLq4FB0ETwA