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 approx_count(column1) from table1; C. select count_distinct(column1 approx) from table1;View AnswerAnswer: A Explanation: APPROX_COUNT_DISTINCT Uses HyperLogLog to return an approximation of the distinct cardinality of...
Your company developed a mobile game that is deployed on Google Cloud. Gamers are connecting to the game with their personal phones over the Internet. The game sends UDP packets to update the servers about the gamers' actions while they are playing in multiplayer mode. Your game backend can scale...
If your role does not own the share, but owns the objects in the share, how can you block access to the objectsA . Revoking the USAGE or SELECT privileges with CASCADE on the objects from the share owner. B. Revoking the USAGE or SELECT privileges on the objects from...
Universal Containers' sales operations team needs to provide visibility on sales pipeline changes on a monthly basis. How should the consultant meet this requirement?A . Create an Opportunity History report for open pipeline Opportunities in a given date range. B. Create a custom pipeline date range field and display it...
What are the four symptoms of alcohol dependence?A . Craving Loss of control Physical dependence Tolerance B. Impaired reflexes Slurred speech Uncontrollable drowsiness C. Impaired reflexes Anger Uncontrollable drowsiness D. Craving Loss of control Anger ToleranceView AnswerAnswer: A
True or False: Fulfilling the requirements means that we delighted our customerA . True B. FalseView AnswerAnswer: B
Which BGP attribute Is used to detect touting loops?A . AS path B. MED C. local preference D. next hopView AnswerAnswer: A
After identifying the potential causes for delays in communicating demand information up the supply chain, the trading partners should take which of the following actions?A . Implement a higher-speed data communications network. B. Change procedures so data is communicated more frequently. C. Identify the root causes for the delays. D....
Out of the three query optimization techniques(search optimization, clustering and materialized view) which one does not have storage costA . Search Optimization Service B. Materialized View C. Clustering the TableView AnswerAnswer: C Explanation: The following table shows which of these three optimizations have storage or compute costs:
{"stuId":2000,"stuCourse":"Snowflake"} How will you write a query that will check if stuId in JSON in #1 is also there in JSON in#2A . with stu_demography as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000, "stuName":"Amy"}')), B. stu_course as (select parse_json(column1) as src, src:stuId as ID from values('{"stuId":2000,"stuCourse":"Snowflake"}')) select case...
