- All Exams Instant Download
Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk
Bytes spilled to remote storage in query profile indicates volume of data spilled to remote diskA . TRUE B. FALSEView AnswerAnswer: A Explanation: This question may come in various format in the exam, so let us not mug it up. Let us understand what it means. When you run large...
{"stuId":2000,"stuCourse":"Snowflake"}
{"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...
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadmin
In the default access control hierarchy, both securityadmin and sysadmin are owned by accountadminA . TRUE B. FALSEView AnswerAnswer: A Explanation: Role hierarchy is an important concept that you should read thoroughly. More than one question may appear in the exam on this topic. Please remember in snowflake you cannot...
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve. What may be the most possible cause of this.A...
