최신Snowflake SnowPro Advanced Architect Certification - ARA-C01무료샘플문제
문제1
A company's table, employees, was accidentally replaced with a new version.
How can the original table be recovered with the LEAST operational overhead?
A company's table, employees, was accidentally replaced with a new version.
How can the original table be recovered with the LEAST operational overhead?
정답: B
설명: (ITDumpsKR 회원만 볼 수 있음)
문제2
What is a key consideration when setting up search optimization service for a table?
What is a key consideration when setting up search optimization service for a table?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제3
A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.
What would be the MOST efficient way to load data from the vendor into Snowflake?
A company has an external vendor who puts data into Google Cloud Storage. The company's Snowflake account is set up in Azure.
What would be the MOST efficient way to load data from the vendor into Snowflake?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제4
A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously and efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?
A media company needs a data pipeline that will ingest customer review data into a Snowflake table, and apply some transformations. The company also needs to use Amazon Comprehend to do sentiment analysis and make the de-identified final data set available publicly for advertising companies who use different cloud providers in different regions.
The data pipeline needs to run continuously and efficiently as new records arrive in the object storage leveraging event notifications. Also, the operational complexity, maintenance of the infrastructure, including platform upgrades and security, and the development effort should be minimal.
Which design will meet these requirements?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
The following chart represents the performance of a virtual warehouse over time:
A Data Engineer notices that the warehouse is queueing queries. The warehouse is sizeX-Small, theminimum and maximum cluster counts are set to 1, thescaling policy is set to standard, andauto-suspend is set to 10 minutes.
How can the performance be improved?
The following chart represents the performance of a virtual warehouse over time:
A Data Engineer notices that the warehouse is queueing queries. The warehouse is sizeX-Small, theminimum and maximum cluster counts are set to 1, thescaling policy is set to standard, andauto-suspend is set to 10 minutes.
How can the performance be improved?
정답: A
문제6
A company has two databases, DB1 and DB2.
Role R1 has SELECT on DB1.
Role R2 has SELECT on DB2.
Users should normally access only one database, but a small group must access both databases in the same query with minimal operational overhead.
What is the best approach?
A company has two databases, DB1 and DB2.
Role R1 has SELECT on DB1.
Role R2 has SELECT on DB2.
Users should normally access only one database, but a small group must access both databases in the same query with minimal operational overhead.
What is the best approach?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제7
A 2 TB table with 400 columns is queried frequently to calculate average employee tenure by country and career level. The query exhibits poor partition pruning and runs on an X-Small warehouse.
What improvement meets the requirements with the LEAST operational overhead?
A 2 TB table with 400 columns is queried frequently to calculate average employee tenure by country and career level. The query exhibits poor partition pruning and runs on an X-Small warehouse.
What improvement meets the requirements with the LEAST operational overhead?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제8
A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?
A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?
정답: A
설명: (ITDumpsKR 회원만 볼 수 있음)
문제9
An Architect wants to alter a virtual warehouse for horizontal scaling but cannot find minimum and maximum cluster settings in the interface, even with the ACCOUNTADMIN role.
What is the MOST likely issue?
An Architect wants to alter a virtual warehouse for horizontal scaling but cannot find minimum and maximum cluster settings in the interface, even with the ACCOUNTADMIN role.
What is the MOST likely issue?
정답: C
설명: (ITDumpsKR 회원만 볼 수 있음)
문제10
Which parameters can only be set at the account level? (Select TWO).
Which parameters can only be set at the account level? (Select TWO).
정답: A,B
설명: (ITDumpsKR 회원만 볼 수 있음)