A Web-Based Front End for a Business Intelligence Application Uses

question 96

Multiple Choice

A web-based front end for a business intelligence application uses pass-through authentication to authenticate users. The application then uses a service account to perform queries and look up data in a database. A security analyst discovers employees are accessing data sets they have not been authorized to use. Which of the following will fix the cause of the issue?

• A) Change the security model to force the users to access the database as themselves
• B) Parameterize queries to prevent unauthorized SQL queries against the database
• C) Configure database security logging using syslog or a SIEM
• D) Enforce unique session IDs so users do not get a reused session ID

---

Definitions:

Lichens

Symbiotic organisms composed of a fungi and a photosynthetic partner, usually an alga or cyanobacterium, living together in a mutually beneficial relationship.

Yeasts

Yeasts are single-celled fungi that are widely used in food production, especially in baking and brewing, due to their ability to ferment.

Chemoautotroph

An organism that derives its energy from chemicals and synthesizes its own organic compounds from carbon dioxide.

Mutualism

In ecology, a symbiotic relationship in which both partners benefit from the association. Compare with parasitism and commensalism.