RBAC - 10

RBAC - 10

Professional Development

5 Qs

quiz-placeholder

Similar activities

Designing and Developing Digital Learning Resources

Designing and Developing Digital Learning Resources

Professional Development

10 Qs

Flipped Classroom - Basics

Flipped Classroom - Basics

Professional Development

4 Qs

Recursion

Recursion

Professional Development

10 Qs

Skill assessment and motivation

Skill assessment and motivation

Professional Development

6 Qs

NetApp Partner Webinar, 24 June 2020

NetApp Partner Webinar, 24 June 2020

Professional Development

10 Qs

Training Methodology

Training Methodology

Professional Development

8 Qs

Managing User with Microsoft Entra ID

Managing User with Microsoft Entra ID

Professional Development

10 Qs

MSSC CPT 4.0 Quality Practices & Measurements Exam Review

MSSC CPT 4.0 Quality Practices & Measurements Exam Review

11th Grade - Professional Development

4 Qs

RBAC - 10

RBAC - 10

Assessment

Quiz

Instructional Technology

Professional Development

Medium

Created by

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

Media Image

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:

c
b
d
e
a

PUBLIC

USERADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN