Buy Latest Feb 19, 2024 ARA-C01 Exam Q&A PDF - One Year Free Update
Download the Latest ARA-C01 Dump - 2024 ARA-C01 Exam Questions
NEW QUESTION # 29
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
Answer: A
NEW QUESTION # 30
To increase performance, materialized views can be created on external table without any additional cost
- A. TRUE
- B. FALSE
Answer: B
NEW QUESTION # 31
Arrange in order of performance(least to high)
1. External Table
2. External Table with partitioning
3. Materialized View Vs External table
4. Directly querying a file from the stage
- A. 1,2,4,3
- B. 1,2,3,4
- C. 3,2,4,1
- D. 4,3,2,1
Answer: B
NEW QUESTION # 32
Databases created from shares cannot be replicated
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 33
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. Rename the STAGING schema and perform an UNDROP to retrieve the previous STAGING schema version, then run the CLONE statement.
- C. Undrop the STAGING schema and then rerun the CLONE statement.
- D. Cloning cannot be accomplished because the STAGING schema version was not active during the proposed Time Travel time period.
Answer: B
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 # 34
Which Snowflake data modeling approach is designed for BI queries?
- A. 3 NF
- B. Star schema
- C. Snowflake schema
- D. Data Vault
Answer: C
NEW QUESTION # 35
What are purposes for creating a storage integration? (Choose three.)
- A. Store a generated identity and access management (IAM) entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account.
- 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. Manage credentials from multiple cloud providers in one single Snowflake object.
- E. Support multiple external stages using one single Snowflake object.
- F. Avoid supplying credentials when creating a stage or when loading or unloading data.
Answer: A,E,F
Explanation:
Explanation
* A storage integration is a Snowflake object that stores a generated identity and access management (IAM) entity for an external cloud provider, such as Amazon S3, Google Cloud Storage, or Microsoft Azure Blob Storage. This integration allows Snowflake to read data from and write data to an external storage location referenced in an external stage1.
* One purpose of creating a storage integration is to support multiple external stages using one single Snowflake object. An integration can list buckets (and optional paths) that limitthe locations users can specify when creating external stages that use the integration. Note that many external stage objects can reference different buckets and paths and use the same storage integration for authentication1.
Therefore, option C is correct.
* Another purpose of creating a storage integration is to avoid supplying credentials when creating a stage or when loading or unloading data. Integrations are named, first-class Snowflake objects that avoid the need for passing explicit cloud provider credentials such as secret keys or access tokens. Integration objects store an IAM user ID, and an administrator in your organization grants the IAM user permissions in the cloud provider account1. Therefore, option D is correct.
* A third purpose of creating a storage integration is to store a generated IAM entity for an external cloud provider regardless of the cloud provider that hosts the Snowflake account. For example, you can create a storage integration for Amazon S3 even if your Snowflake account is hosted on Azure or Google Cloud Platform. This allows you to access data across different cloud platforms using Snowflake1.
Therefore, option B is correct.
* Option A is incorrect, because creating a storage integration does not control access to Snowflake data using a master encryption key. Snowflake encrypts all data using a hierarchical key model, and the master encryption key is managed by Snowflake or by the customer using a cloud provider's key management service. This is independent of the storage integration feature2.
* Option E is incorrect, because creating a storage integration does not create private VPC endpoints.
Private VPC endpoints are a network configuration option that allow direct, secure connectivity between VPCs without traversing the public internet. This is also independent of the storage integration feature3.
* Option F is incorrect, because creating a storage integration does not manage credentials from multiple cloud providers in one single Snowflake object. A storage integration is specific to one cloud provider, and you need to create separate integrations for each cloud provider you want to access4.
References: : Encryption and Decryption : Private Link for Snowflake : CREATE STORAGE INTEGRATION : Option 1: Configuring a Snowflake Storage Integration to Access Amazon S3
NEW QUESTION # 36
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)
- A. A task scheduled in a UTC-based schedule will have no issues with the time changes.
- B. Task schedules can be designed to follow specified or local time zones to accommodate the time changes.
- C. A task will move to a suspended state during the daylight savings time change.
- D. A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.
- E. A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.
Answer: A,B
Explanation:
Explanation
According to the Snowflake documentation1 and the web search results2, these two statements are true about how the change of local time due to daylight savings time is handled in Snowflake tasks. A task is a feature that allows scheduling and executing SQL statements or stored procedures in Snowflake. A task can be scheduled using a cron expression that specifies the frequency and time zone of the task execution.
* A task scheduled in a UTC-based schedule will have no issues with the time changes. UTC is a universal time standard that does not observe daylight savings time. Therefore, a task that uses UTC as the time zone will run at the same time throughout the year, regardless of the local time changes1.
* Task schedules can be designed to follow specified or local time zones to accommodate the time changes. Snowflake supports using any valid IANA time zone identifier in the cron expression for a task. This allows the task to run according to the local time of the specified time zone, which may include daylight savings time adjustments. For example, a task that uses Europe/London as the time zone will run one hour earlier or later when the local time switches between GMT and BST12.
References:
* Snowflake Documentation: Scheduling Tasks
* Snowflake Community: Do the timezones used in scheduling tasks in Snowflake adhere to daylight savings?
NEW QUESTION # 37
There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?
- A. USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db
- B. USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db
- C. USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db
- D. MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db
Answer: C
NEW QUESTION # 38
You have an inventory table. You created two views on this table. The views look like as below
CREATE VIEW NON_SECURE_INVENTORY AS
SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
FROM INVENTORY
WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
CREATE SECURE VIEW SECURE_INVENTORY AS
SELECT BIBNUMBER, TITLE, AUTHOR,ISBN
FROM INVENTORY
WHERE BIBNUMBER IN(511784,511805,511988,512044,512052,512063);
You ran the below queries
ALTER SESSION SET USE_CACHED_RESULT=FALSE;--This is to ensure that we do not retrieve from query cache
SELECT * FROM NON_SECURE_INVENTORY WHERE BIBNUMBER =511784; SELECT * FROM SECURE_INVENTORY WHERE BIBNUMBER =511784;
The query profile for the first query looks as below
However, the query profile for the second one looks like as below
Both the views use the same columns from the same underlying view. So, why is this difference in query profiles.
- A. Secure views do not expose the underlying tables or internal structural details for a view
- B. The query profile is corrupted
- C. The query is run by a role that did not have access to the view
Answer: A
NEW QUESTION # 39
A stream stores data with the same columns as the source data but with additional columns.
What are those additional columns?
- A. METADATA$ISUPDATE
- B. METADATA$DELETE
- C. METADATA$ACTION
- D. METADATA$ROW_ID
Answer: A,C,D
NEW QUESTION # 40
Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION # 41
What is the data size limit for loading into a variant column?
- A. 32 GB
- B. 1 GB(Compressed)
- C. 16 MB(Compressed)
- D. 10 MB - 100 MB compressed
Answer: C
NEW QUESTION # 42
Below are the rest APIs provided by Snowpipe
- A. insertReport
- B. loadData
- C. insertFiles
Answer: A,C
NEW QUESTION # 43
Data replication in snowflake helps in
- A. Disaster recovery
- B. Data sharing
- C. Fail safe
- D. Account Migration
Answer: A,B,D
NEW QUESTION # 44
......
Verified ARA-C01 Dumps Q&As - 1 Year Free & Quickly Updates: https://www.actual4cert.com/ARA-C01-real-questions.html
Latest Snowflake ARA-C01 Certification Practice Test Questions: https://drive.google.com/open?id=1iU-G2hPhlCZLj_ArrGTR6NJDNf8_uvOL