Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

C2090-632 by IBM - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 2 • Questions 1-25 of 50

1 2

→

Know a question that should be here? Contribute to this exam

In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?

A To generate the most efficient SQL at run time and simplify model maintenance.
B To prevent the exclusion of columns from a table that may be required in future reports.
C To prevent improperly constructed SQL and reduce issues with model documentation and readability.
D To provide authors with access to all columns in a database table which reduces requests to the modeler.

Which of the following join types does the generated SQL below illustrate? select
✑ Manager.Manager as Manager,
✑ Product.Product as Product
from
✑ datasource_name.database_name.schema.Manager Manager
✑ datasource_name.database_name.schema.Product Product

A Inner join
B Disjointed join
C Outer join
D Cross join

In Framework Manager, which of the following statements is correct when working with a multi-lingual project?

A The design languages can be changed at any point.
B A project language cannot be deleted once defined in Framework Manager.
C A language must be added to the project before it can be published with a package.
D When a new language is added to a project, all locales for that language are added as well.

Which of the following is true regarding the operational data structure illustrated below?

Question Image

A It illustrates a parallel relationship.
B It should be consolidated into one table.
C It should be examined for a connection trap.
D The cardinality between the tables should be reversed.

Which of the following are proven practices for organizing the objects in a project?

A When importing metadata from more than once data source, include all imported objects in the root namespace.
B When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.
C When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.
D When importing metadata from more than one data source, do not override the relationships defined between the data source at the time of import.

In Framework Manager, which of the following is the true about verifying your model?

A The entire model must be verified, individual objects cannot be verified.
B The model can only be verified through the Publish Package wizard.
C The model can be verified from Cognos Connection or through the Publish Packages wizard.
D It is possible to select to automatically repair certain issues that have been detected.

Which technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

A Create relationships from date fields in one dimension to date fields in another dimension.
B Use parameter maps to map date values in one query subject to date values in another query subject.
C Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.
D Identify a time dimension table source, import into the model and create relationships to fact query subjects.

Which of the following is true applying object security in Framework Manager?

A If beginning to apply security by specifying object security on an object with no children, all other objects remain accessible to all users.
B If beginning to apply security by specifying object security on an object with no children, all other objects will not be accessible to all users.
C Allows overrides Deny if specified in the properties of the object.
D Child objects only inherit security from their parent if the Inherit property is set to YES.

In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

A Create stand-alone filters.
B Add performance indicators to functions.
C Configure data sources in a project pointing to the same instance to use the same connection.
D For a query item having an integer data type, set the Display Item Reference property to display an integer value.

Which of the following components does a basic Cognos 10 stitch query consist of?

A SC() function, full outer join, multiply queries that each query exclusive information.
B SC() function, full outer join, multiple queries that query of the same information.
C Coalesce function, full outer join, multiple queries that each query exclusive information.
D Coalesce function, full outer join, multiple queries that query some of the same information.