IBM C1000-197 Practice Questions with Explanations

Free IBM C1000-197 practice questions. 20 of them, each with the correct answer, a full explanation, and the reason every other option is wrong.

C1000-197 practice questions

Question 1

What is an accumulation interval in Correlation Alerts?

  • A. How often to send notifications from an alert.
  • B. How many events to accumulate before sending an alert.
  • C. How many alerts to accumulate before sending notification.
  • D. How far back to run the query in the alert definition.
Show answer and explanation ▾

Correct answer: B

A correlation alert is based on a query. The accumulation interval sets the span over which matching events are gathered and counted, and that accumulated result is compared with the threshold before the alert is sent.

Why the other options are wrong:

  • A. How often notifications are sent is set by the notification frequency, not by the accumulation interval.
  • C. The interval applies to the events counted by the alert query, not to a count of alerts.
  • D. How often the alert query runs is set separately by the run frequency in the alert definition.

Question 2

How is an SMTP configuration verified?

  • A. Checking the syslog messages via fileserver.
  • B. Running a test email using the iptraf command.
  • C. Reviewing the ‘Failed Messages’ report.
  • D. Testing the connection in the Alerter section.
Show answer and explanation ▾

Correct answer: D

An SMTP setup is checked by testing the connection from the Alerter section of the Guardium configuration. That confirms the appliance can reach the mail server.

Why the other options are wrong:

  • A. Syslog messages through a file server say nothing about the SMTP connection.
  • B. iptraf is a network traffic monitor, not a way to send a test email.
  • C. The Failed Messages report is not how you verify a new SMTP setup.

Question 3

Which command should be started to upgrade a Windows S-TAP agent from the command line?

  • A. setup -NOAUTODISCOVERY
  • B. setup -UNATTENDED
  • C. setup -UPGRADE
  • D. setup -UPGRADESTAP
Show answer and explanation ▾

Correct answer: C

The Windows S-TAP installer is run from the command line as setup, and the -UPGRADE option tells it to upgrade an agent that is already installed.

Why the other options are wrong:

  • A. This option does not start an upgrade of the installed agent.
  • B. This option runs the installer without prompts and does not by itself tell it to upgrade.
  • D. This is not the installer option that upgrades the Windows S-TAP.

Question 4

Which component must be configured first to create Alert Builder e-mail notifications?

  • A. Alert Templates
  • B. Predefined Alerts
  • C. Syslog
  • D. SMTP
Show answer and explanation ▾

Correct answer: D

Guardium sends alert e-mails through the Alerter, which needs an SMTP server defined. SMTP must be configured before e-mail notifications created in the Alert Builder can be delivered.

Why the other options are wrong:

  • A. Alert templates only format the message text and cannot deliver mail without SMTP.
  • B. Predefined alerts are ready-made alert definitions, not a prerequisite for sending e-mail.
  • C. Syslog is a different notification target and is not needed for e-mail.

Question 5

Which action is performed using Investigation Dashboard?

  • A. Creating, saving, and exporting investigation dashboards for forensic analysis.
  • B. Modifying Guardium’s core analytics engine settings to enhance real-time processing.
  • C. Deleting Guardium audit logs to improve performance.
  • D. Disabling automatic recovery of critical security alerts.
Show answer and explanation ▾

Correct answer: A

The Investigation Dashboard is used to explore audit data interactively. Users can build dashboards with filters and charts, save them and export them to support forensic analysis.

Why the other options are wrong:

  • B. The dashboard is a data exploration tool and does not change analytics engine settings.
  • C. Audit logs are not deleted from the Investigation Dashboard.
  • D. The dashboard does not control alert recovery settings.

Question 6

Which two (2) jobs does Database Auto-Discovery use to ensure that no database goes undetected in the environment? (Choose two.)

  • A. Discovery job
  • B. Scan job
  • C. Database job
  • D. Audit Process job
  • E. Probe job
Show answer and explanation ▾

Correct answer: B, E

Auto-discovery uses two jobs. A scan job checks each specified host or subnet and lists the open ports, then a probe job uses the scan results to find database services running on those ports.

Why the other options are wrong:

  • A. Discovery job is not one of the two job types that Auto-discovery runs.
  • C. Database job is not a job type used by Auto-discovery.
  • D. An audit process job runs compliance workflow tasks, not database discovery.

Question 7

Which component is recommended for the assessment tests and datasource definitions for Vulnerability Assessment in an Enterprise deployment?

  • A. Aggregator
  • B. Collector
  • C. Central Manager
  • D. CAS Server
Show answer and explanation ▾

Correct answer: B

In an enterprise deployment, the assessment tests and the datasource definitions they run against are recommended to be kept on a collector.

Why the other options are wrong:

  • A. The aggregator is not the recommended unit for these definitions.
  • C. The Central Manager is not the recommended unit for these definitions.
  • D. CAS is an agent installed on the database server, not a Guardium unit that holds the assessment and datasource definitions.

Question 8

What is the required step to ensure a successful restore when archived data is stored on an external EMC Centera storage, and the archive was created on a different Guardium system?

  • A. Import the EMC Centera storage configuration file using the CLI.
  • B. Upload the SFTP credentials directly to the Guardium appliance.
  • C. Ensure the system shared secret from the original system is available on the target system.
  • D. Run the delete_entry_location GuardAPI command on the target appliance.
Show answer and explanation ▾

Correct answer: C

Archived data is encrypted using the system shared secret of the appliance that created it. To restore an archive made on a different Guardium system, the shared secret of the original system must be available on the target system.

Why the other options are wrong:

  • A. Importing a storage configuration file is not the step that allows data from another system to be restored.
  • B. SFTP credentials are not used for EMC Centera storage and do not allow the restored data to be decrypted.
  • D. This command removes catalog entries and does not prepare a restore.

Question 9

Which function improves data security?

  • A. Creating secure audit repository for large number of systems, networks, and databases.
  • B. Assessing network vulnerabilities and configuration flaws.
  • C. Tracking end user activity who never access data through enterprise applications.
  • D. Monitoring activity on sensitive data access, database changes, and privileged user actions.
Show answer and explanation ▾

Correct answer: D

Guardium improves data security by monitoring activity in real time, covering access to sensitive data, changes to databases and the actions of privileged users, so that risky behavior is detected and can be acted on.

Why the other options are wrong:

  • A. A secure audit repository supports compliance reporting; it stores records and does not by itself protect the data.
  • B. Guardium assesses database vulnerabilities, not network vulnerabilities.
  • C. This statement does not describe a function that improves data security.

Question 10

What needs to be enabled to utilize the deployment health views?

  • A. Data imports and exports
  • B. Alerts in Policy actions
  • C. Unit utilization data
  • D. Enterprise S-TAP view report
Show answer and explanation ▾

Correct answer: C

The deployment health views are built from utilization data reported by the managed units, so the collection of unit utilization data has to be enabled before the views show results.

Why the other options are wrong:

  • A. Data imports and exports are not the setting that is enabled to gather the health data shown in these views.
  • B. Alerts in policy actions are not the setting that is enabled for the deployment health views.
  • D. This report lists S-TAP status and does not need to be enabled for the deployment health views.

Question 11

What is the purpose of Domains in Query-Report Builder?

  • A. They organize related Entities and Attributes.
  • B. They store raw database logs before processing.
  • C. They act as predefined reports for compliance audits.
  • D. They define access control rules for user roles.
Show answer and explanation ▾

Correct answer: A

A domain in the Query-Report Builder groups related entities and their attributes for one area of collected data, so a query is built by choosing a domain and then picking from its entities and attributes.

Why the other options are wrong:

  • B. Domains are a way of organizing data for queries, not a store for raw logs.
  • C. Domains are not reports; reports are built from queries on a domain.
  • D. Access to data is controlled through roles, not through domains.

Question 12

A Guardium administrator has successfully installed an S-TAP agent for Informix. However, encrypted and shared memory traffic is not being collected.

Which monitoring mechanism captures this traffic when enabled?

  • A. PCAP
  • B. KTAP
  • C. ATAP
  • D. EXIT
Show answer and explanation ▾

Correct answer: B

K-TAP is the kernel module of the S-TAP. When it is enabled, it intercepts traffic between the database server and its clients inside the operating system, including local connections that never cross the network.

Why the other options are wrong:

  • A. PCAP captures network packets and does not see shared memory traffic.
  • C. This is not the mechanism that collects the traffic in this scenario.
  • D. This is not the mechanism that collects the traffic in this scenario.

Question 13

What are two (2) types of rules within a data security policy? (Choose two.)

  • A. SQL
  • B. Extrusion
  • C. Access
  • D. Selective
  • E. Session
Show answer and explanation ▾

Correct answer: B, C

A data security policy is built from access rules, which evaluate the requests sent to the database, extrusion rules, which evaluate the data returned by the database, and exception rules, which evaluate errors.

Why the other options are wrong:

  • A. SQL is not a rule type in a data security policy.
  • D. Selective describes a kind of audit policy, not a rule type.
  • E. Session is not a rule type in a data security policy.

Question 14

Which CLI command checks if a Guardium appliance can communicate with the SMTP server?

  • A. support tcpdump -i host smtp_server_ip port port#
  • B. support store tcpdump interface smtp_server_ip port# tcp
  • C. support show port open smtp_server_ip port#
  • D. support netconnection --computername smtp_server_name port#
Show answer and explanation ▾

Correct answer: A

The support tcpdump CLI command captures network packets on the appliance. Filtering on the SMTP server address and port shows whether traffic is flowing between the appliance and the mail server.

Why the other options are wrong:

  • B. This is not a valid Guardium CLI command for checking the connection to the SMTP server.
  • C. This is not a valid Guardium CLI command for checking the connection to the SMTP server.
  • D. This is not a valid Guardium CLI command for checking the connection to the SMTP server.

Question 15

Which operating system user is required to install the S-TAP client on a Linux database server?

  • A. guardium
  • B. root
  • C. admin
  • D. guardadmin
Show answer and explanation ▾

Correct answer: B

Installing the S-TAP on a Linux database server loads a kernel module and writes system files, so the installation has to be run by the root user.

Why the other options are wrong:

  • A. This is not an operating system account that the Linux S-TAP installation requires.
  • C. This is not the operating system account that the Linux S-TAP installation requires.
  • D. This is not an operating system account that the Linux S-TAP installation requires.

Question 16

Which role allows performing routine maintenance on the system, such as restarting services, without granting access to sensitive data or configurations?

  • A. Admin-console-only
  • B. System-admin
  • C. Maintenance
  • D. Admin
Show answer and explanation ▾

Correct answer: C

The Maintenance role is meant for routine upkeep of the system, such as restarting services, and it does not open up the audit data or the wider configuration.

Why the other options are wrong:

  • A. This is not the role intended for routine maintenance tasks.
  • B. This is not the role intended for routine maintenance tasks.
  • D. The admin role gives broad administrative access, which is more than routine maintenance needs.

Question 17

Which two (2) components/artifacts are utilized by the Guardium Vulnerability Assessment? (Choose two.)

  • A. Workflow
  • B. Report
  • C. Test
  • D. Compliance
  • E. Datasource
Show answer and explanation ▾

Correct answer: C, E

A Guardium vulnerability assessment is defined by the datasources it connects to and the tests it runs against them. The tests check settings, privileges and patch levels, and each datasource supplies the database connection details.

Why the other options are wrong:

  • A. A workflow is used to distribute and review results; it is not a building block of the assessment.
  • B. A report shows the results after the assessment has run.
  • D. Compliance is a goal that assessments support, not a component of one.

Question 18

Where are the must gather files stored when the support must_gather command is run?

  • A. Fileserver
  • B. Healthcheck log Page
  • C. Support Information Gathering Results Page
  • D. /tmp directory in the DB server
Show answer and explanation ▾

Correct answer: A

The support must_gather command writes its output files on the appliance, and they are collected by starting the fileserver CLI command and downloading them from the fileserver page in a browser.

Why the other options are wrong:

  • B. The must gather files are not stored on a health check log page.
  • C. This page is not where files created by the CLI command are retrieved.
  • D. The files are created on the Guardium appliance, not on the database server.

Question 19

Which is the correct wildcard operator that is used in a query condition?

  • A. %ghdp%
  • B. jcfku*
  • C. aaa#
  • D. *c.c*
Show answer and explanation ▾

Correct answer: A

Query conditions use the LIKE operator with the percent sign as the wildcard, so %ghdp% matches any value that contains the string ghdp.

Why the other options are wrong:

  • B. The asterisk is not the wildcard character used in a query condition.
  • C. The number sign is not a wildcard character in a query condition.
  • D. The asterisk is not the wildcard character used in a query condition.

Question 20

The customer has completed the Guardium and QRadar integration.

Which is true about Guardium policy where the new member is added to the associated group by the QRadar event?

  • A. The Guardium policy is automatically reinstalled.
  • B. The Guardium policy must be reinstalled manually.
  • C. The only one-way information flow is supported between Guardium and QRadar.
  • D. The generated GuardAPI script manually updates Guardium policy.
Show answer and explanation ▾

Correct answer: A

When a QRadar event adds a member to a group that an installed policy uses, Guardium reinstalls the policy automatically, so the new group member takes effect without an administrator stepping in.

Why the other options are wrong:

  • B. A manual reinstall is not needed after the group is updated.
  • C. The integration works in both directions: Guardium sends events to QRadar and QRadar can update Guardium groups.
  • D. The policy is not updated by running a generated script by hand.

That was 20 of 60.

The full IBM C1000-197 pack has all 60 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. $39.00 USD, paid once, with free monthly updates and a pass-or-your-money-back guarantee.

Get the full pack

Not ready yet? Get the first 21 free as one PDF by email. Get the Half Pack →

About the C1000-197 exam

These 20 IBM C1000-197 questions are free here. The free PDF has 21, free by email.

They are drawn from the same bank as the full C1000-197 pack, which has 60 questions in total.

Back to blog