[May-2023] Snowflake ARA-C01 Exam Practice Test Questions - TorrentValid
Updated Certification Exam ARA-C01 Dumps - Practice Test Questions
NEW QUESTION 42
The insertReport endpoint can be thought of like the UNIX command tail
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 43
A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?
- A. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
- B. GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
- C. GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
Answer: B
NEW QUESTION 44
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$ROW_ID
- C. METADATA$ACTION
- D. METADATA$DELETE
Answer: A,B,C
NEW QUESTION 45
Select the true statement
- A. Privileges are granted to roles. Roles are granted to users
- B. Privileges are granted to users. Users are granted to roles
- C. Privileges are granted to both roles and users
Answer: A
NEW QUESTION 46
Search optimization does not support Materialized views and External Tables
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 47
One of your colleagues has submitted a long running query in Snowflake. how long the query can run till snowflake automatically cancels the query?
- A. 14 hours
- B. 2 hours
- C. 2 days
- D. 24 hours
Answer: C
NEW QUESTION 48
Which of the two are limitations of the insertReport API of SnowPipe?
- A. The 10,000 most recent events are retained
- B. Events are retained for a maximum of 10 minutes
- C. Events are retained for a maximum of 24 hours
Answer: A,B
NEW QUESTION 49
Please select the correct hierarchy from below
- A. Option B
- B. Option D
- C. Option C
- D. Option A
Answer: C
NEW QUESTION 50
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,3,4
- B. 4,3,2,1
- C. 1,2,4,3
- D. 3,2,4,1
Answer: A
NEW QUESTION 51
You have set time-travel retention to 10 days. You now increase the retention period by 10 more days to make it 20 days.
What will be the impact on the table data?
- A. Any data which has not reached the 10 days time-travel period, will now have time-travel extended for 20 days
- B. Any data that is 10 days older and moved to fail-safe will not have any impact
- C. Changes will impact only new data
Answer: A,B
NEW QUESTION 52
Privileges granted on database objects are not replicated to a secondary database.
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 53
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 54
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
- A. An error is returned and no changes are applied to the column
- B. Snowflake automatically assigns a default value and let the change happen
- C. Snowflake drops the row and let the change happen
Answer: A
NEW QUESTION 55
What is the best practice to follow when calling the SNOWPIPE REST API loadHistoryScan
- A. Reading the last 10 minutes of history every 8 minutes
- B. Read the last 7 days of history every hour
- C. Read the last 24 hours of history every minute
Answer: A
NEW QUESTION 56
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 57
One of your joins is taking a lot of time. The query profile view looks like this.
What may be the issue?
- A. This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in a cartesian product
- B. There is not enough memory to process the join query
- C. Looks like tablescan is the most expensive operation in the profile.
Answer: A
NEW QUESTION 58
When a cloned table is replicated to a secondary database, the data also gets replicated in the secondary database
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 59
Cloud services can help in pruning even if the columns are variant columns.
- A. TRUE
- B. FALSE
Answer: A
NEW QUESTION 60
Which command below will only copy the table structure from the existing table to the new table?
- A. CREATE TABLE ... LIKE
- B. CREATE TABLE ... CLONE
- C. CREATE TABLE ... AS SELECT
Answer: A
NEW QUESTION 61
You will be using a multi cluster warehouse. You will statically control the available resources (i.e. servers) and you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.
Which mode will you use for the warehouse?
- A. Maximized
- B. Auto-Scale
- C. Minimized
Answer: A
NEW QUESTION 62
You have a medium warehouse with auto suspend of 5 minutes. You ran a query on table#1. After 10 minutes, you ran a query that joins table#1 and table#2, but you see that the query did not use data
cache.
Why?
- A. Joins cannot use any type of cache
- B. The query that ran the second time is completely different from query that ran on table#1, hence it will not be able to use data cache
- C. When a warehouse is suspended, it may lose its data cache
Answer: C
NEW QUESTION 63
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
Answer: A
NEW QUESTION 64
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.
Which is that role?
- A. IMPORT SHARE
- B. SHARED PRIVILEGES
- C. IMPORTED PRIVILEGES
Answer: C
NEW QUESTION 65
One of your query is taking a long time to finish, when you open the query profiler you see that lot of data is spilling to the remote disk(Bytes spilled to remote storage).
What may be the cause of this?
- A. Number of disks attached to the virtual warehouse is not enough for the processing
- B. The amount of memory available for the servers used to execute the operation might not be sufficient to hold intermediate results
- C. The size of the AWS bucket used to hold the data is not sufficient for the query
Answer: B
NEW QUESTION 66
Which statement is true about clustering key?
- A. Clustering key can be many per table and each key can have more than one column
- B. Clustering key can be many per table but each key can have only one column
- C. Clustering key can be one per table but the key can have more than one column
Answer: C
NEW QUESTION 67
......
Updated Verified ARA-C01 dumps Q&As - Pass Guarantee or Full Refund: https://www.torrentvalid.com/ARA-C01-valid-braindumps-torrent.html
ARA-C01 PDF Questions and Testing Engine With 156 Questions: https://drive.google.com/open?id=17yt0zKPU7GuiRip43It0LGjmn5qzoTvt