The task of assigning data classifications to resources is the responsibility of which security role? The task of assigning data classifications to resources is the responsibility of which security role? Custodian Owner Security staff Operator
Added by Robert L.
Step 1
** Show more…
Show all steps
Your feedback will help us improve your experience
Breanna Ollech and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Tech Srilanka is a software company who has expertise in developing secure software applications the banking sector. As such, one of the leading private bank has given the responsibility of automating their tasks to Tech Srilanka. This includes developing a database to record customer details, account details, branch details and all the other functions related to a bank. Malaka is the senior project manager responsible for the entire project. Malaka has asked Ishara who is the senior DBA, to handle the database development and management process. This includes creating a secure database to the bank. Accordingly, she has designed the bankab. Since there will be lot of users for the project, Kalpa is assigned with the responsibility of creating logins to the system. Surani is assigned to create tables, required views, stored procedures and triggers. Aruna and Maliths who are data entry operators are given the responsibility of inserting the data to ye tables. Heshan should be able to generate reports as well as directly query the data or call functions and procedures.Assuming that ishara has a server login named isharak, which of the following statements would you need to provide her with the permission she need using a role named manager , Select one or more:a. create role managergrant obcreator to manager alter server role manager add member ishara.kb. create server user managercreate server role manager grant create any database to manager alter server role manager add member ishara.kd. create permission add database to manager grant server role manager to ishara kDe create server role manager grant permission create database to manager grant server role manager add member isharak
Breanna O.
Techwire Lanka is a software company who has expertise in developing secure software applications the hotel industry. As such, a reputed global hotel chain has given the responsibility of automating their tasks to Techwire Lanka. Nalaka is the project manager responsible for the entire project. Nalaka has asked Malani who is the senior DBA to handle the database development and management process. This includes creating a secure database to the hotel. Malani is responsible for handling all the hotel reservations and bookings. Accordingly, she has designed the hoteldb. Since there will be lot of users for the project. Sonal is assigned with the responsibility of handling logins to the system. Akram is assigned to create tables, required views, stored procedures and triggers. Palika and Mahesh who are data entry operators are given the responsibility of inserting the data to the tables. With the data added to the database, Aruni should be able to generate reports as well as directly query the data or call functions and procedures.Assuming that Malani has a login by the name malani.k. Which of the following T-SQL statement/s required to assign her with the responsibility of handling the hoteldb.Select one or more: a. ALTER ROLE db_datareader add member malani.k b. ALTER ROLE dbcreator add member malani.k c. ALTER ROLE db_owner ADD MEMBER malani.k d. ALTER ROLE sysadmin add member malani.k e. ALTER ROLE db_ddladmin add member malani.k
Match the roles with the role's descriptions: Information Resource Manager Systems Administrator Database Administrator (DBA) Data Administrator (DA) Database Security Officer (DSO) User In many organizations the Data Administrator is known by this title. This person may access the database depending upon business requirements. This person's sole job is to ensure database security and integrity. In large organizations. This person is the general coordinator of all DBAs. The person responsible for control of the centralized and shared database. This person usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA.
Cameron B.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD