🌍 All Study Guides📊 Dashboard📰 Blog💡 About
IBM Cybersecurity Analyst Professional Certificate • STUDY MODE

PRACTICE QUIZ

QUESTION 1 OF 35

True or False: If all of your organization's data is centralized in a small number of data centers, than focusing security on perimiter defense is adequate to assure your data is safe.

A
a' True
B
b' FalseCorrect Answer
C
Correct, If all of your organization's data is centralized in a small number of data centers, than focusing security on perimiter defense is not adequate to assure your data is safe.
QUESTION 2 OF 35

Which two (2) of the following data source types are considered structured data?

A
a' Data warehousesCorrect Answer
B
b' Big data databases
C
c' Distributed databasesCorrect Answer
D
d' File Shares
E
Correct, this is considered structured.
QUESTION 3 OF 35

Data that has not been organized into a specialized repository, but does have associated information, such as metadata that makes it more amenable to processing than raw data, is an example of which data model type?

A
a' Raw data
B
b' Structured data
C
c' Unstructured data
D
d' Semi-structured dataCorrect Answer
QUESTION 4 OF 35

How are the tables in a relational database linked together?

A
a' Tables are organized in a hierarchical manner so Table 2 always follows Table 1 and so forth.
B
b' Through the use of primary and foreign keys.Correct Answer
C
c' Table connection diagrams are defined in the database configuration settings.
D
d' By adding a pointer as the last field of each record in a table that points to the first field in the next table.
E
Correct, through the use of primary and foreign keys.
F
SECURING DATABASES
QUESTION 5 OF 35

In the video Securing the Crown Jewels, the "Identification and Baseline" phase contains which three (3) of the following items?

A
a' Blocking & Quarantine
B
b' Activity Monitoring
C
c' Discovery & ClassificationCorrect Answer
D
d' Vulnerability AssessmentCorrect Answer
E
e' Entitlements ReportingCorrect Answer
F
Partially correct, this is one of the three.
QUESTION 6 OF 35

In the video Leveraging Security Industry Best Practices, which US Government agency is a co-publisher of the Database Security Requirements Guide (SRG)?

A
a' Federal Bureau of Investigation (FBI)
B
b' Central Intelligence Agency (CIA)
C
c' Department of Defense (DoD)Correct Answer
D
d' Center for Internet Security (CIS)
QUESTION 7 OF 35

For added security, a firewall is often placed between which of these?

A
a' The client and the application.
B
b' The database and the hardened data repository.Correct Answer
C
c' The database administrator and the database.
D
d' The application and the database.
E
Correct, the database and the hardened data repository.
QUESTION 8 OF 35

True or False: In a vulnerability assessment test, a new commercial database installed on a new instance of a major operating system should pass 80-90% of the vulnerability tests out-of-the-box unless there is a major flaw or breach.

A
a' True
B
b' FalseCorrect Answer
QUESTION 9 OF 35

Which of these hosting environments requires the enterprise to manage the largest number of different data sources?

A
a' PaaS
B
b' On PremisesCorrect Answer
C
c' SaaS
D
d' IaaS
QUESTION 10 OF 35

While data security is an ongoing process, what is the correct order to consider these steps?

A
a' Discover, Monitor & Protect, Harden, Repeat
B
b' Discover, Harden, Monitor & Protect, RepeatCorrect Answer
C
c' Harden, Discover, Monitor & Protect, Repeat
D
d' Monitor & Protect, Discover, Harden, Repeat
E
A DATA PROTECTION SOLUTION EXAMPLE, IBM SECURITY GUARDIUM USE CASES
QUESTION 11 OF 35

In setting up policy rules for data monitoring, what is the purpose of "exclude" rules?

A
a' To exclude certain commands from being executed.
B
b' To exclude individual accounts from accessing data.
C
c' To exclude certain applications or safe activities from being logged.Correct Answer
D
d' To exclude someone from accessing certain database tables.
E
Correct, To exclude certain applications or safe activities from being logged.
QUESTION 12 OF 35

True or False: Data monitoring products such as IBM Guardium can send access alerts to syslog for manual intervention by a security analyst but must be connected to addition applications if automated interventions are desired.

A
a' True
B
b' FalseCorrect Answer
QUESTION 13 OF 35

To created auditable reports of data access using the IBM Guardium product, the administrator would do which of the following?

A
a' All standard reports are considered auditable.
B
b' Develop a custom report and turn on Audit Locking to assure the results cannot be tampered with.
C
c' Use the Audit Process Builder feature to automate the reporting process.Correct Answer
D
d' Export standard access logs to Excel or another reporting tool for sorting and processing.
E
Correct, All standard reports are considered auditable.
QUESTION 14 OF 35

True or False: The IBM Guardium monitoring applications is capable of monitoring activities in non-relational databases such as Hadoop, Cognos, and Spark.

A
a' TrueCorrect Answer
B
b' False
QUESTION 15 OF 35

At a minimum, which 3 entities should be captured in any event log?

A
a' When the activity took place.Correct Answer
B
b' Which database tables were associated with the activity.
C
c' Who or what committed the activity.Correct Answer
D
d' Whether the attempted activity was completed successfully.
E
e' What activity took place.Correct Answer
F
Partially correct, you answered one of the three.
QUESTION 16 OF 35

True of False: In the IBM Guardium data monitoring tool, the number of failed login attempts that would trigger an alert are always counted since the last successful login.

A
a' True
B
b' FalseCorrect Answer
QUESTION 17 OF 35

Which activity should be considered suspicious and might indicate inappropriate activity is being attempted?

A
a' A known user attempts to run invalid SQL statements against data his ID is authorized to access.
B
b' A user routinely enters the incorrect password once or twice before entering the correct password for his account.
C
c' Data accessed by an accounting application dramatically increases in the last few days of every month.
D
d' Attempts are made to access data using nonstandard tools, such as MS Excel or MS Access, rather than through the application the data belongs to.Correct Answer
E
Correct, Attempts are made to access data using nonstandard tools, such as MS Excel or MS Access, rather than through the application the data belongs to.
QUESTION 18 OF 35

Which two (2) activities should be considered suspicious and warrant further investigation?

A
a' Use of an Application ID from an IP that is different from what has been specified by the application owner.Correct Answer
B
b' An authorized user attempts to run SQL statements with invalid syntax.
C
c' Use of an Application ID from a hostname that is different from what has been specified by the application owner.Correct Answer
D
d' It takes an authorized user 3 attempts to enter the correct password.
E
Partially correct, this is one of the correct answers.
F
INTRODUCTION TO DATABASES
QUESTION 19 OF 35

Distributed databases, data warehouses, big data, and File shares are all classified as what?

A
a' Data models
B
b' Database types
C
c' Data source typesCorrect Answer
D
d' Data center types
QUESTION 20 OF 35

Hadoop, MongoDB, and BigTable are all examples of which data source type?

A
a' Data warehouses
B
b' Big data databasesCorrect Answer
C
c' Distributed databases
D
d' File Shares
QUESTION 21 OF 35

Data that has been organized into a formatted repository, typically a database, so its elements can be made addressable, is an example of which data model type?

A
a' Structureless data
B
b' Semi-structured data
C
c' Unstructured data
D
d' Structured dataCorrect Answer
QUESTION 22 OF 35

Which of the following is the primary difference between a flat file database and a relational database?

A
a' All the data in a relational database is stored in a single table.
B
b' All the data in a flat file database is stored in a single table.Correct Answer
C
c' Flat file databases consist of a table that references internally stored files.
D
d' Flat file databases consist of a table that references externally stored files.
QUESTION 23 OF 35

In the video Leveraging Security Industry Best Practices, where would you turn to look for help on establishing security benchmarks for your database?

A
a' Common Vulnerability and Exposures (CVE).
B
b' Center for Internet Security (CIS).Correct Answer
C
c' Department of Defense/Defence Information Systems Agency (DoD/DISA).
D
d' Central Intelligence Agency (CIA).
QUESTION 24 OF 35

Most of the time, how do users access data?

A
a' Through an application.Correct Answer
B
b' Through a database client.
C
c' Directly from a hardened repository.
D
d' Directly from a database.
QUESTION 25 OF 35

True or False: In a vulnerability assessment test, it is not uncommon to fail more than 50% of the tests before the operating system and database are hardened.

A
a' TrueCorrect Answer
B
b' False
QUESTION 26 OF 35

What distinguishes structured data from unstructured data?

A
a' Structured data is associated with metadata, while unstructured data relies on specialized repositories such as databases.
B
b' Structured data is harder to access and process than unstructured data.
C
c' Structured data is data organized into a formatted repository, making it easily addressable, whereas unstructured data lacks any form of organization.Correct Answer
D
d' Structured data is the least organized and hardest to understand, while unstructured data is the most formatted.
QUESTION 27 OF 35

To automatically terminate a session if an attempt is made to access data in a sensitive table, such as Social Security (SSN) ID numbers, you would set up which type of rule?

A
a' An Aggregator rule.
B
b' An Access rule.Correct Answer
C
c' An Exception rule.
D
d' An Exclude rule.
QUESTION 28 OF 35

True or False: Data monitoring products such as IBM Guarduim are fully capable of blocking access to sensitive data based upon access parameters configured in policy rules.

A
a' TrueCorrect Answer
B
b' False
QUESTION 29 OF 35

True or False: Data monitoring tools such as IBM Guardium are designed to monitor activities within a database, but external products, such as a privileged identity management (PIM) tool would be required to monitor changes to the data monitoring tool itself, such as the addition of new users or the alteration of existing user accounts.

A
a' True
B
b' FalseCorrect Answer
QUESTION 30 OF 35

True or False: In the IBM Guardium data monitoring tool, it is possible to create a report that shows not only how many SQL unauthorized access attempts were made by an individual, but also exactly which SQL statements were disallowed.

A
a' TrueCorrect Answer
B
b' False
QUESTION 31 OF 35

True or False: If all of your organization’s data is centralized in a small number of data centers, than focusing security on perimiter defense is adequate to assure your data is safe.

A
True 
B
FalseCorrect Answer
QUESTION 32 OF 35

In the video Securing the Crown Jewels, the “Identification and Baseline” phase contains which three (3) of the following items?

A
Blocking & Quarantine
B
Activity Monitoring
C
Discovery & ClassificationCorrect Answer
D
Vulnerability AssessmentCorrect Answer
E
Entitlements ReportingCorrect Answer
QUESTION 33 OF 35

In setting up policy rules for data monitoring, what is the purpose of “exclude” rules?

A
To exclude certain commands from being executed.
B
To exclude individual accounts from accessing data.
C
To exclude certain applications or safe activities from being logged.Correct Answer
D
To exclude someone from accessing certain database tables.
QUESTION 34 OF 35

What distinguishes structured data from unstructured data? 

A
Structured data is associated with metadata, while unstructured data relies on specialized repositories such as databases. 
B
Structured data is harder to access and process than unstructured data. 
C
Structured data is data organized into a formatted repository, making it easily addressable, whereas unstructured data lacks any form of organization.Correct Answer
D
Structured data is the least organized and hardest to understand, while unstructured data is the most formatted. 
QUESTION 35 OF 35

True or False: Data monitoring products such as IBM Guarduim are fully capable of blocking access to sensitive data based upon access parameters configured in policy rules. 

A
TrueCorrect Answer
B
False

Ready to test your recall?

True or False: If all of your organization's data is centralized in a small number of data centers, than focusing security on perimiter defense is adequate to assure your data is safe.

A
a' True
B
b' False
C
Correct, If all of your organization's data is centralized in a small number of data centers, than focusing security on perimiter defense is not adequate to assure your data is safe.

How confident are you in this answer?