Free 365 Days Exam Updates ARA-C01 dumps with test Engine Practice [Q50-Q73]

Free 365 Days Exam Updates ARA-C01 dumps with test Engine Practice

Updated Verified ARA-C01 dumps Q&As - 100% Pass Guaranteed

NEW QUESTION # 50
Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

• A. Choose lower cardinality columns to support clustering keys and cost effectiveness.
• B. Choose TIMESTAMP columns with nanoseconds for the highest number of unique rows.
• C. Choose columns that are frequently used in join predicates.
• D. Choose cluster columns that are actively used in the GROUP BY clauses.
• E. Choose cluster columns that are most actively used in selective filters.

Answer: C,E

Explanation:
According to the Snowflake documentation, the best practices for choosing clustering keys are:
Choose columns that are frequently used in join predicates. This can improve the join performance by reducing the number of micro-partitions that need to be scanned and joined.
Choose columns that are most actively used in selective filters. This can improve the scan efficiency by skipping micro-partitions that do not match the filter predicates.
Avoid using low cardinality columns, such as gender or country, as clustering keys. This can result in poor clustering and high maintenance costs.
Avoid using TIMESTAMP columns with nanoseconds, as they tend to have very high cardinality and low correlation with other columns. This can also result in poor clustering and high maintenance costs.
Avoid using columns with duplicate values or NULLs, as they can cause skew in the clustering and reduce the benefits of pruning.
Cluster on multiple columns if the queries use multiple filters or join predicates. This can increase the chances of pruning more micro-partitions and improve the compression ratio.
Clustering is not always useful, especially for small or medium-sized tables, or tables that are not frequently queried or updated. Clustering can incur additional costs for initially clustering the data and maintaining the clustering over time.
Reference:
Clustering Keys & Clustered Tables | Snowflake Documentation
[Considerations for Choosing Clustering for a Table | Snowflake Documentation]

NEW QUESTION # 51
At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

• A. Schema
• B. Global
• C. Table
• D. Database

Answer: B

Explanation:
Explanation
The object type level at which the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges can be granted is global. These are account-level privileges that control who can apply or unset these policies on objects such as columns, tables, views, accounts, or users. These privileges are granted to the ACCOUNTADMIN role by default, and can be granted to other roles as needed.
The other options are incorrect because they are not the object type level at which these privileges can be granted. Database, schema, and table are lower-level object types that do notsupport these privileges. References: Access Control Privileges | Snowflake Documentation, Using Dynamic Data Masking | Snowflake Documentation, Using Row Access Policies | Snowflake Documentation, Using Session Policies | Snowflake Documentation

NEW QUESTION # 52
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. C2, C1, C3
• C. C1, C3, C2
• D. C3, C4, C5

Answer: B

NEW QUESTION # 53
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 SHARE;
• C. CREATE DATABASE;
• D. CREATE SHARE;
• E. IMPORT DATABASE;

Answer: C,E

Explanation:
Explanation
According to the Snowflake documentation, to create a database from an inbound share, the user's role must have the following privileges:
* The CREATE DATABASE privilege on the current account. This privilege allows the user to create a new database in the account1.
* The IMPORT DATABASE privilege on the share. This privilege allows the user to import a database from the share into the account2. The other privileges listed are not relevant for this requirement. The IMPORT SHARE privilege is used to import a share into the account, not a database3. The IMPORT PRIVILEGES privilege is used to import the privileges granted on the shared objects, not the objects themselves2. The CREATE SHARE privilege is used to create a share to provide data to other accounts, not to consume data from other accounts4.
References:
* CREATE DATABASE | Snowflake Documentation
* Importing Data from a Share | Snowflake Documentation
* Importing a Share | Snowflake Documentation
* CREATE SHARE | Snowflake Documentation

NEW QUESTION # 54
A company is designing high availability and disaster recovery plans and needs to maximize redundancy and minimize recovery time objectives for their critical application processes. Cost is not a concern as long as the solution is the best available. The plan so far consists of the following steps:
1. Deployment of Snowflake accounts on two different cloud providers.
2. Selection of cloud provider regions that are geographically far apart.
3. The Snowflake deployment will replicate the databases and account data between both cloud provider accounts.
4. Implementation of Snowflake client redirect.
What is the MOST cost-effective way to provide the HIGHEST uptime and LEAST application disruption if there is a service event?

• A. Connect the applications using the <organization_name>-<accountLocator> URL. Use the Enterprise Snowflake edition.
• B. Connect the applications using the <organization_name>-<accountLocator> URL. Use the Business Critical Snowflake edition.
• C. Connect the applications using the <organization_name>-<connection_name> URL. Use the Virtual Private Snowflake (VPS) edition.
• D. Connect the applications using the <organization_name>-<connection_name> URL. Use the Business Critical Snowflake edition.

Answer: A

NEW QUESTION # 55
What will the below query return
SELECT TOP 10 GRADES FROM STUDENT;

• A. The top 10 highest grades
• B. The 10 lowest grades
• C. Non-deterministic list of 10 grades

Answer: C

NEW QUESTION # 56
You have created a table as below
CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP );
Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE.
Which command below will you choose?

• A. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR, BLOG_CREATE_DATE);
• B. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_CREATE_DATE);
• C. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR)

Answer: A

NEW QUESTION # 57
Which of the following are characteristics of Snowflake's parameter hierarchy?

• A. Virtual warehouse parameters override user parameters.
• B. Session parameters override virtual warehouse parameters.
• C. Table parameters override virtual warehouse parameters.
• D. Schema parameters override account parameters.

Answer: B

NEW QUESTION # 58
USERADMIN and Security administrators (i.e. users with the SECURITYADMIN role) or higher can create roles.

• A. TRUE
• B. FALSE

Answer: A

NEW QUESTION # 59
A company is storing large numbers of small JSON files (ranging from 1-4 bytes) that are received from IoT devices and sent to a cloud provider. In any given hour, 100,000 files are added to the cloud provider.
What is the MOST cost-effective way to bring this data into a Snowflake table?

• A. A pipe
• B. An external table
• C. A stream
• D. A copy command at regular intervals

Answer: A

Explanation:
A pipe is a Snowflake object that continuously loads data from files in a stage (internal or external) into a table. A pipe can be configured to use auto-ingest, which means that Snowflake automatically detects new or modified files in the stage and loads them into the table without any manual intervention1.
A pipe is the most cost-effective way to bring large numbers of small JSON files into a Snowflake table, because it minimizes the number of COPY commands executed and the number of micro-partitions created. A pipe can use file aggregation, which means that it can combine multiple small files into a single larger file before loading them into the table. This reduces the load time and the storage cost of the data2.
An external table is a Snowflake object that references data files stored in an external location, such as Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage. An external table does not store the data in Snowflake, but only provides a view of the data for querying. An external table is not a cost-effective way to bring data into a Snowflake table, because it does not support file aggregation, and it requires additional network bandwidth and compute resources to query the external data3.
A stream is a Snowflake object that records the history of changes (inserts, updates, and deletes) made to a table. A stream can be used to consume the changes from a table and apply them to another table or a task. A stream is not a way to bring data into a Snowflake table, but a way to process the data after it is loaded into a table4.
A copy command is a Snowflake command that loads data from files in a stage into a table. A copy command can be executed manually or scheduled using a task. A copy command is not a cost-effective way to bring large numbers of small JSON files into a Snowflake table, because it does not support file aggregation, and it may create many micro-partitions that increase the storage cost of the data5.

NEW QUESTION # 60
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. Add the IP address in the error message to the allowed list in the network policy.
• D. Alter the Azure security integration to use the Private Link URLs.
• E. Update the configuration of the Azure AD SSO to use the Private Link URLs.

Answer: B,C

NEW QUESTION # 61
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. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
• B. Ingest the data using Snowpipe and use streams and tasks to orchestrate transformations. Create an external function to do model inference with Amazon Comprehend and write the final records to a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
• C. Ingest the data using copy into and use streams and tasks to orchestrate transformations. Export the data into Amazon S3 to do model inference with Amazon Comprehend and ingest the data back into a Snowflake table. Then create a listing in the Snowflake Marketplace to make the data available to other companies.
• D. Ingest the data into Snowflake using Amazon EMR and PySpark using the Snowflake Spark connector. Apply transformations using another Spark job. Develop a python program to do model inference by leveraging the Amazon Comprehend text analysis API. Then write the results to a Snowflake table and create a listing in the Snowflake Marketplace to make the data available to other companies.

Answer: B

NEW QUESTION # 62
A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines.
Which actions can the company take with the inbound share? (Choose two.)

• A. Grant modify permissions on the share.
• B. Create a table from the shared database.
• C. Create additional views inside the shared database.
• D. Clone a table from a share.
• E. Create a table stream on the shared table.

Answer: B,E

NEW QUESTION # 63
A company needs to share its product catalog data with one of its partners. The product catalog data is stored in two database tables: product_category, and product_details. Both tables can be joined by the product_id column. Data access should be governed, and only the partner should have access to the records.
The partner is not a Snowflake customer. The partner uses Amazon S3 for cloud storage.
Which design will be the MOST cost-effective and secure, while using the required Snowflake features?

• A. Create a database user for the partner and give them access to the required data sets.
• B. Use Secure Data Sharing with an S3 bucket as a destination.
• C. Create a reader account for the partner and share the data sets as secure views.
• D. Publish product_category and product_details data sets on the Snowflake Marketplace.

Answer: C

Explanation:
A reader account is a type of Snowflake account that allows external users to access data shared by a provider account without being a Snowflake customer. A reader account can be created and managed by the provider account, and can use the Snowflake web interface or JDBC/ODBC drivers to query the shared data. A reader account is billed to the provider account based on the credits consumed by the queries1. A secure view is a type of view that applies row-level security filters to the underlying tables, and masks the data that is not accessible to the user. A secure view can be shared with a reader account to provide granular and governed access to the data2. In this scenario, creating a reader account for the partner and sharing the data sets as secure views would be the most cost-effective and secure design, while using the required Snowflake features, because:
It would avoid the data transfer and storage costs of using an S3 bucket as a destination, and the potential security risks of exposing the data to unauthorized access or modification.
It would avoid the complexity and overhead of publishing the data sets on the Snowflake Marketplace, and the potential loss of control over the data ownership and pricing.
It would avoid the need to create a database user for the partner and grant them access to the required data sets, which would require the partner to have a Snowflake account and consume the provider's resources.
Reference:
Reader Accounts
Secure Views

NEW QUESTION # 64
Which of the below query will you run to get the approximate number of distinct values in a table?

• A. select approx_count_distinct(column1) from table1;
• B. select count_distinct(column1 approx) from table1;
• C. select approx_count(column1) from table1;

Answer: A

NEW QUESTION # 65
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the table which they will query using complex aggregation logic. You know that querying with those columns will take a lot of time because the table is not clustered on those columns.
What is the most optimal solution that you will suggest to the business team?

• A. CREATE A SECURE VIEW
• B. CREATE A REGULAR VIEW
• C. CREATE A MATERIALIZED VIEW AND CLUSTER THE VIEW ON THOSE COLUMNS

Answer: C

NEW QUESTION # 66
An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects.
The STAGING schema has 50 days of retention.
The Architect runs the following statement:
CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time.
The Architect then checks the schema history and sees the following:
CREATED_ON|NAME|DROPPED_ON
2021-06-02 23:00:00 | STAGING | NULL
2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00
How can cloning the STAGING schema be achieved?

• A. Modify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp =>
  '2021-05-01 10:00:00');
• B. Undrop the STAGING schema and then rerun the CLONE statement.
• C. Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.
• D. Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.

Answer: D

Explanation:
Explanation
* The error message indicates that the schema STAGING does not have time travel data available for the requested timestamp, because the current version of the schema was created on2021-06-02 23:00:00, which is after the timestamp of 2021-06-01 08:00:00. Therefore, the CLONE statement cannot access the historical data of the schema at that point in time.
* Option A is incorrect, because undropping the STAGING schema will not restore the previous version of the schema that was active on 2021-06-01 08:00:00. Instead, it will create a new version of the schema with the same name and no data or objects.
* Option B is incorrect, because modifying the timestamp to 2021-05-01 10:00:00 will not clone the schema as it looked one week ago, but as it looked when it was first created. This may not reflect the desired state of the schema and its objects.
* Option C is correct, because renaming the STAGING schema and performing an UNDROP to retrieve the previous STAGING schema version will restore the schema that was dropped on 2021-06-02
23:00:00. This schema has time travel data available for the requested timestamp of 2021-06-01
08:00:00, and can be cloned using the CLONE statement.
* Option D is incorrect, because cloning can be accomplished by using the UNDROP command to access the previous version of the schema that was active during the proposed time travel period.
References: : Cloning Considerations : Understanding & Using Time Travel : CREATE <object> ... CLONE

NEW QUESTION # 67
EXECUTE TASK privilege can be granted by whom

• A. SECURITYADMIN
• B. ROLE WHO OWNS THE TASK
• C. ACCOUNTADMIN

Answer: C

NEW QUESTION # 68
Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)

• A. Creating an account
• B. Changing the name of an account
• C. Changing the name of the organization
• D. Viewing a list of organization accounts
• E. Deleting an account
• F. Enabling the replication of a database

Answer: A,D,F

Explanation:
According to the SnowPro Advanced: Architect documents and learning resources, the organization-related tasks that can be performed by the ORGADMIN role are:
Creating an account in the organization. A user with the ORGADMIN role can use the CREATE ACCOUNT command to create a new account that belongs to the same organization as the current account1.
Viewing a list of organization accounts. A user with the ORGADMIN role can use the SHOW ORGANIZATION ACCOUNTS command to view the names and properties of all accounts in the organization2. Alternatively, the user can use the Admin a Accounts page in the web interface to view the organization name and account names3.
Enabling the replication of a database. A user with the ORGADMIN role can use the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to enable database replication for an account in the organization. This allows the user to replicate databases across accounts in different regions and cloud platforms for data availability and durability4.
The other options are incorrect because they are not organization-related tasks that can be performed by the ORGADMIN role. Option A is incorrect because changing the name of the organization is not a task that can be performed by the ORGADMIN role. To change the name of an organization, the user must contact Snowflake Support3. Option D is incorrect because changing the name of an account is not a task that can be performed by the ORGADMIN role. To change the name of an account, the user must contact Snowflake Support5. Option E is incorrect because deleting an account is not a task that can be performed by the ORGADMIN role. To delete an account, the user must contact Snowflake Support. Reference: CREATE ACCOUNT | Snowflake Documentation, SHOW ORGANIZATION ACCOUNTS | Snowflake Documentation, Getting Started with Organizations | Snowflake Documentation, SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER | Snowflake Documentation, ALTER ACCOUNT | Snowflake Documentation, [DROP ACCOUNT | Snowflake Documentation]

NEW QUESTION # 69
A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements.
Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

• A. Create accounts for each tenant in the Snowflake organization.
• B. Create an object for each tenant strategy if row level security is viable for isolating tenants.
• C. Create an object for each tenant strategy if row level security is not viable for isolating tenants.
• D. Create a multi-tenant table strategy if row level security is not viable for isolating tenants.

Answer: A

NEW QUESTION # 70
Below are the rest APIs provided by Snowpipe

• A. loadData
• B. insertReport
• C. insertFiles

Answer: B,C

NEW QUESTION # 71
A company is using Snowflake in Azure in the Netherlands. The company analyst team also has data in JSON format that is stored in an Amazon S3 bucket in the AWS Singapore region that the team wants to analyze.
The Architect has been given the following requirements:
1. Provide access to frequently changing data
2. Keep egress costs to a minimum
3. Maintain low latency
How can these requirements be met with the LEAST amount of operational overhead?

• A. Use a materialized view on top of an external table against the S3 bucket in AWS Singapore.
• B. Use an external table against the S3 bucket in AWS Singapore and copy the data into transient tables.
• C. Copy the data between providers from S3 to Azure Blob storage to collocate, then use Snowpipe for data ingestion.
• D. Use AWS Transfer Family to replicate data between the S3 bucket in AWS Singapore and an Azure Netherlands Blob storage, then use an external table against the Blob storage.

Answer: B

NEW QUESTION # 72
While choosing a cluster key, what is recommended by snowflake?

• A. Cluster columns that are most actively used in selective filters
• B. If there is room for additional cluster keys, then consider columns frequently used in join predicates
• C. Choose a key with high cardinality

Answer: A,B

NEW QUESTION # 73
......

Provide Valid Dumps To Help You Prepare For SnowPro Advanced Architect Certification Exam: https://actualtests.crampdf.com/ARA-C01-exam-prep-dumps.html