If you want to provide a share to many accounts, you might want to use a listing or a data ex-change.
Question 2
Secure Data Sharing do not let you share which of the following selected objects in a database in your account with other Snowflake accounts?
Options:
A.
Sequences
B.
Tables
C.
External tables
D.
Secure UDFs
Answer:
A
Explanation:
Explanation:
Explanation
Secure Data Sharing lets you share selected objects in a database in your account with other Snow-flake accounts. You can share the following Snowflake database objects:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.
Question 3
Which of the Following is not type of Windows function in Snowflake?
Options:
A.
Rank-related functions.
B.
Window frame functions.
C.
Aggregation window functions.
D.
Association functions.
Answer:
C, D
Explanation:
Explanation:
Explanation
Window Functions
A window function operates on a group (“window”) of related rows.
Each time a window function is called, it is passed a row (the current row in the window) and the window of rows that contain the current row. The window function returns one output row for each input row. The output depends on the individual row passed to the function and the values of the other rows in the window passed to the function.
Some window functions are order-sensitive. There are two main types of order-sensitive window functions:
Rank-related functions.
Window frame functions.
Rank-related functions list information based on the “rank” of a row. For example, if you rank stores in descending order by profit per year, the store with the most profit will be ranked 1; the second-most profitable store will be ranked 2, etc.
Window frame functions allow you to perform rolling operations, such as calculating a running total or a moving average, on a subset of the rows in the window.