Microsoft MTA 98-364 Database
Fundamentals UPDATED ACTUAL Exam
Questions and CORRECT Answers
What should the end result of a database security plan? - CORRECT ANSWER - ensure
all user assigned rights and responsibilities are enforced through the security plan
What is a user permission used for? - CORRECT ANSWER - It is used to grant an entity
(such as a user) access to an object such as another user or database.
The SQL Server Model is based on securables. Allowing access based on different objects. What
are 5 different objects? - CORRECT ANSWER - [DTLUR] databases, tables, logins,
users, and roles
What 5 options come up when you add > New under Security to a database using SSMS -
CORRECT ANSWER - [UDASD] User, Database Role, Application Role, Schema,
Database Audit Specification
SSMS When Adding a New User what options are available on the General Tab of the Window -
CORRECT ANSWER - User Name - Type it in
Login Name - Select windows user or window group
Default Schema - Select
Owned Schemas - checkbox
Role Members - checkbox
What is the SQL Syntax to Create a login with domain\username - CORRECT ANSWER -
CREATE LOGIN 'XPS\Car'
What is the SQL Syntax to Remove a login with domain\username - CORRECT
ANSWER - DROP LOGIN 'XPS\Car'
, Will dropping a Login remove the Windows user or Group? - CORRECT ANSWER - No,
the user or group will still exists, however it will no longer be recognized by SQL Server
What is Mixed Mode? - CORRECT ANSWER - Allows you to connect to SQL using
Windows Authentication or SQL Server Authentication
What is SQL Server Authentication? - CORRECT ANSWER - A security authentication
where the login is defined on the SQL server and are not related to Active Directory or Windows
Account
What is the sa account? - CORRECT ANSWER - Built in SQL Administrators account
BUILTINS/Administrator includes all users in the Windows Administrator user group when
installed - it can be modified or deleted after installation
What are 3 kinds of Database server roles? - CORRECT ANSWER - Fixed, Public and
User defined
What are Fixed server roles? - CORRECT ANSWER - Predefined Server Roles already in
SQL. Primarily users to grant permission to server related administrative tasks. Users can belong
to more than one fixed role
What is Bulkadmin fixed server role? - CORRECT ANSWER - Can perform bulk insert
operations
What is Dbcreator fixed server role? - CORRECT ANSWER - Can create, alter, drop and
restore databases
What is Diskadmin fixed server role? - CORRECT ANSWER - Can create, alter and drop
disk files
Fundamentals UPDATED ACTUAL Exam
Questions and CORRECT Answers
What should the end result of a database security plan? - CORRECT ANSWER - ensure
all user assigned rights and responsibilities are enforced through the security plan
What is a user permission used for? - CORRECT ANSWER - It is used to grant an entity
(such as a user) access to an object such as another user or database.
The SQL Server Model is based on securables. Allowing access based on different objects. What
are 5 different objects? - CORRECT ANSWER - [DTLUR] databases, tables, logins,
users, and roles
What 5 options come up when you add > New under Security to a database using SSMS -
CORRECT ANSWER - [UDASD] User, Database Role, Application Role, Schema,
Database Audit Specification
SSMS When Adding a New User what options are available on the General Tab of the Window -
CORRECT ANSWER - User Name - Type it in
Login Name - Select windows user or window group
Default Schema - Select
Owned Schemas - checkbox
Role Members - checkbox
What is the SQL Syntax to Create a login with domain\username - CORRECT ANSWER -
CREATE LOGIN 'XPS\Car'
What is the SQL Syntax to Remove a login with domain\username - CORRECT
ANSWER - DROP LOGIN 'XPS\Car'
, Will dropping a Login remove the Windows user or Group? - CORRECT ANSWER - No,
the user or group will still exists, however it will no longer be recognized by SQL Server
What is Mixed Mode? - CORRECT ANSWER - Allows you to connect to SQL using
Windows Authentication or SQL Server Authentication
What is SQL Server Authentication? - CORRECT ANSWER - A security authentication
where the login is defined on the SQL server and are not related to Active Directory or Windows
Account
What is the sa account? - CORRECT ANSWER - Built in SQL Administrators account
BUILTINS/Administrator includes all users in the Windows Administrator user group when
installed - it can be modified or deleted after installation
What are 3 kinds of Database server roles? - CORRECT ANSWER - Fixed, Public and
User defined
What are Fixed server roles? - CORRECT ANSWER - Predefined Server Roles already in
SQL. Primarily users to grant permission to server related administrative tasks. Users can belong
to more than one fixed role
What is Bulkadmin fixed server role? - CORRECT ANSWER - Can perform bulk insert
operations
What is Dbcreator fixed server role? - CORRECT ANSWER - Can create, alter, drop and
restore databases
What is Diskadmin fixed server role? - CORRECT ANSWER - Can create, alter and drop
disk files
