[2023] Use Valid Exam ARA-C01 by Actual4test Books For Free Website
Free SnowPro Advanced Certification ARA-C01 Official Cert Guide PDF Download
NEW QUESTION # 45
A table contains five columns and it has millions of records. The cardinality distribution of the columns is shown below:
Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses. Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
- A. C5, C4, C2
- B. C3, C4, C5
- C. C1, C3, C2
- D. C2, C1, C3
Answer: D
NEW QUESTION # 46
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 47
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. Update the configuration of the Azure AD SSO to use the Private Link URLs.
- B. Alter the Azure security integration to use the Private Link URLs.
- C. Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
- D. Add the IP address in the error message to the allowed list in the network policy.
- E. Open a case with Snowflake Support to authorize the Private Link URLs' access to the account.
Answer: C,D
NEW QUESTION # 48
To increase performance, materialized views can be created on external table without any additional cost
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION # 49
USERADMIN and Security administrators (i.e. users with the SECURITYADMIN role) or higher can create roles.
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 50
Which of the below privileges are required for search optimization?
- A. ADD SEARCH OPTIMIZATION privilege on the table.
- B. OWNERSHIP privilege on the table
- C. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
Answer: B,C
NEW QUESTION # 51
Materialized views based on external tables can improve query performance
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 52
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
Answer: D
NEW QUESTION # 53
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage cost
- A. Clustering the Table
- B. Materialized View
- C. Search Optimization Service
Answer: A
NEW QUESTION # 54
Running EXPLAIN on a query does not require a running warehouse
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 55
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.)
- A. IMPORT PRIVILEGES;
- B. IMPORT DATABASE;
- C. CREATE DATABASE;
- D. CREATE SHARE;
- E. IMPORT SHARE;
Answer: A,C
NEW QUESTION # 56
A user can change object parameters using which of the following roles?
- A. SYSADMIN, SECURITYADMIN
- B. SECURITYADMIN, USER with PRIVILEGE
- C. ACCOUNTADMIN, USER with PRIVILEGE
- D. ACCOUNTADMIN, SECURITYADMIN
Answer: D
NEW QUESTION # 57
You want to automatically delete the files from stage after a successful load using the COPY INTO command.
What will be recommended approach for deletion?
- A. Set REMOVE=TRUE in the COPY INTO Command
- B. Set PURGE=TRUE in the COPY INTO command
- C. No need to do anything, snowflake does it automatically
Answer: B
NEW QUESTION # 58
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. The Connector only works in Snowflake regions that use AWS infrastructure.
- C. Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.
- D. The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.
Answer: A
NEW QUESTION # 59
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.
How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)
- A. Use a materialized view on an external table.
- B. Use Snowpipe with auto-ingest.
- C. Use a COPY command with a task.
- D. Use the COPY INTO command.
- E. Use a combination of a task and a stream.
Answer: B,E
NEW QUESTION # 60
To convert JSON null value to SQL null value, you will use
- A. STRIP_NULL_VALUE
- B. IS_NULL_VALUE
- C. NULL_IF
Answer: A
NEW QUESTION # 61
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) 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 - B. 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 - C. 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 - D. 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
Answer: B
NEW QUESTION # 62
Remote service in external function can be an AWS Lambda function
- A. FALSE
- B. TRUE
Answer: B
NEW QUESTION # 63
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 CLONE customer_table
- B. CREATE TABLE customer_table_other AS SELECT * FROM customer_table
- C. ALTER TABLE customer_table_other SWAP WITH customer_table
Answer: A
NEW QUESTION # 64
Following objects can be cloned in snowflake
- A. Temporary table
- B. Permanent table
- C. External tables
- D. Internal stages
- E. Transient table
Answer: A,B,E
NEW QUESTION # 65
You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes.
What will happen to the query?
- A. The query will continue to run
- B. The query will automatically cancelled after 10 minutes
- C. The query will go on a hold state
Answer: A
NEW QUESTION # 66
Schema owner can grant object privileges in a regular schema
- A. FALSE
- B. TRUE
Answer: A
NEW QUESTION # 67
Which of the below commands lists all the pipes for which you have access?
- A. Display Pipes()
- B. SHOW PIPES()
- C. LIST @PIPES
- D. LIST PIPES()
Answer: B
NEW QUESTION # 68
Which alter command below may affect the availability of column with respect to time travel?
- A. ALTER TABLE...SET DEFAULT
- B. ALTER TABLE...DROP COLUMN
- C. ALTER TABLE...SET DATA TYPE
Answer: C
NEW QUESTION # 69
......
Snowflake ARA-C01 Official Cert Guide PDF: https://www.actual4test.com/ARA-C01_examcollection.html
Exam ARA-C01: SnowPro Advanced Architect Certification - Actual4test: https://drive.google.com/open?id=1e1cD3_a_lHLicTCs3Hi-WkzBBRD0W-i0