C2090-305 Exam Questions

Which two components must you identify when building a data connection in Information Analyzer?

What are two characteristics of data rules?

You have been tasked with documenting all fields that contain personal information while performing profiling activities. Which method would you use to accomplish this?

The DSN for the Information Analyzer database needs to be created on which tier?

Which statement about published data rules is correct?

You are evaluating a Price column in an DB2 database and need to identify whether the lowest value in the column is less than 10.00. What steps are needed to evaluate this conditio...

Which statement is NOT true for the installation of Information Analyzer?

Which two statements are relevant to key analysis in Information Analyzer?

A company is starting an Information Analysis project to assess the data quality of Key Performance Indicators (KPIs). They also want to setup on-going monitoring of the data quali...

Which option could you use to limit which records in a table are available for Column Analysis?

You are implementing a rule that evaluates the valid values for an Indicator field. What steps are necessary to tolerate a 1 % error rate in the executed rule?

It is desired to create a data rule to determine how many rows in the master data catalog have a primary shipping location that is not found in the location_number column in the "L...

Which two are NOT valid connectors in Information Analyzer?

What are two properties of global logical variables?

When viewing Column Analysis Summary information, a comment will be indicated by which of the following?

Which output format supports encryption and password protection of the report?

You are analyzing a historical data source with 500 million records with approximately 15 million added per year. You wish to analyze only records from the year 2000. The table con...

While reviewing results of a data rule test, you find a logic error. Which option will allow you to troubleshoot this error?

Which can be done in the Data Rule Stage?

What are the three domain analysis methods?

What are three of the analytical functions used in column analysis?

Which two of the following does a green flag indicate? (Choose two.)

Which describes the purpose of Domain Analysis?

You are reviewing the summary of a data rule on the Information Analyzer Home Page dashboard and see a red exclamation mark. What does it signify?

Which analysis would be used to identify whether a column with a "character" data type contains null values?

Which two of the following statements are relevant to table analysis in Information Analyzer? (Choose two.)

You are installing Information Analyzer and plan to use Oracle as the Information Analyzer analysis database. Which statement is true?

When analyzing large number of columns in Information Analyzer, which two components may require capacity planning review? (Choose two.)

When working with Information Analyzer reports, which two functions require use of the reporting functionality in the Information Server Web Console? (Choose two.)

Which two options are supported for creating Information Analyzer reports in XLS format? (Choose two.)