C2090-625 試験問題を無料オンラインアクセス

A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?

• A.Location of the .ctg file..
• B.Names and port numbers of for Data Manager socket servers.
• C.A default schema name.
• D.Method used to connect to the database.

Over time, an employee may move from one office to another. The dimension table tracks these types of changes. What is this dimension an example of?

• A.Reference dimension
• B.Slowly changing dimension
• C.Metadata dimension
• D.Slowly derived dimension

The data in the Product dimension table appears as follows:

What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?

• A.In the properties of the dimension table, specify that late arriving dimension details are to be written to a table.
• B.In the properties of the underlying hierarchy, set the Multiple Parents feature to Accept.
• C.In the properties of the underlying hierarchy, set the Unbalanced Hierarchy feature to Accept.
• D.In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.

Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?

• A.Data source derivation
• B.Derived measure
• C.DataStream derivation
• D.Derived dimension

A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?

• A.Hierachy wizard
• B.Reference Explorer
• C.SQLTXT Designer
• D.SQLTerm
• E.Navigator