
RBAC - 10

Quiz
•
Instructional Technology
•
Professional Development
•
Medium
Sydney Cucchiara
Used 2+ times
FREE Resource
5 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
1 min • 1 pt
Complete the following sentence?
Privileges are granted to ________.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In the hierarchy shown below, User1
has been granted ROLE_A. What
other roles can they USE?
Role B
Role C
Public and Role B
Role C and PUBLIC
Answer explanation
When you are granted a role, you can
USE that role, and any others that are
connected below it in the hierarchy.
User1 can USE ROLE_A, ROLE_C, or
PUBLIC.
3.
FILL IN THE BLANK QUESTION
1 min • 1 pt
You log into Snowflake and run this
command:
SELECT * FROM tablea;
Snowflake tells you that the object
does not exist, or you are not
authorized – but you know it exists
because you created it.
What should you check?
Answer explanation
• Make sure you are using a role that
has access to the object. If you
created the object under one role, and
now you are using another, you may
not see it.
• Check your context to see if you are
using the correct database and
schema for that object.
• Check for typos!
4.
FILL IN THE BLANK QUESTION
1 min • 1 pt
• ROLE_A and ROLE_B are not
connected in the hierarchy
• ROLE_A can create tables in
PROD_DB.SCHEMA1
• ROLE_B can create tables in
DEV_DB.SCHEMA1
You have access to both roles. What
objects can you create after this:
USE ROLE ROLE_A;
USE SECONDARY ROLES ALL;
Answer explanation
You will be able to create tables in
PROD_DB.SCHEMA1.
When you enable secondary roles, you
only get the create privileges of your
primary role (the one you have chosen to
USE).
5.
LABELLING QUESTION
1 min • 1 pt
Fill out the following to identify the hierarchy of system roles:
PUBLIC
USERADMIN
ACCOUNTADMIN
SYSADMIN
SECURITYADMIN
Similar Resources on Wayground
10 questions
Composites #1

Quiz
•
Professional Development
10 questions
Project Creation

Quiz
•
Professional Development
10 questions
Networking basics

Quiz
•
Professional Development
8 questions
az-104_module-9

Quiz
•
Professional Development
10 questions
ABCTE 1.3

Quiz
•
Professional Development
10 questions
Cuestionario tecnologías digitales

Quiz
•
Professional Development
10 questions
[W0 Jan23] Quizizz for OW

Quiz
•
Professional Development
10 questions
Instructional Learning Experiences

Quiz
•
Professional Development
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade