{"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...
Which of the following actions typically would be considered part of a reverse logistics strategy?A . Offering a discount on new purchases when used products are returned B. Reducing the amount of packaging material used in shipping C. Manufacturing products in batches consistent with full-truckload shipments D. Batching returns of...
A chief audit executive (CAE) reviews the supervision of an internal audit engagement. Which of the following would most likely assure the CAE that the engagement had adequate supervision?A . The engagement supervisor has an open door pokey for audit team members to discuss concerns B. The supervisor reviews weekly...
Which of the following is a process goal in the Construction stage?A . Explore scope B. Develop test strategy C. Prove architecture early D. Form team E. Ensure production readinessView AnswerAnswer: C
A company ships from its manufacturing facilities directly to its warehouses. If the number of warehouses increases, transportation costs between manufacturing facilities and warehouses most likely will:A . increase. B. decrease. C. not change. D. become less predictable.View AnswerAnswer: A
What is the difference between asset protection and security?A . Assets protection includes all security functions, as well as related functions such as investigations, legal oversight, risk management, safety, compliance, and emergency management. B. Assets protection includes only physical security related functions. C. Assets protection includes all security functions, as...
With respect to span of control, the greater the degree of sophistication of interaction between supervisors and subordinates, theA . Broader the optimum span of control B. More difficult it is to identify the optimum span of control C. Narrower the optimum span of control D. More options there are...
An internal auditor is conducting a financial audit. Which of the following audit procedures is most appropriate when existing internal controls are weak?A . Analytical procedures. B. Detail testing. C. Test of design. D. Test of control.View AnswerAnswer: B
An audit observation states the following: "Despite the rules of the organization there is no approved credit risk management policy in the subsidiary. The subsidiary is concluding contacts with clients who have very high credit ratings. The internal audit team tested 50 contacts and 17 showed clients with a poor...
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...
