E10-110 Enterprise Content Management Certify Practice Exam Set 4

What must be done before dropping a custom type from the repository?


Options are :

  • Delete all sub types of the custom type.
  • Migrate the type’s attributes to the super type.
  • Delete all sub types and instances of the custom type, or migrate them to the custom type’s super type.
  • Delete all attributes of the custom type.

Answer : Delete all sub types and instances of the custom type, or migrate them to the custom type’s super type.

What enables the exchange of documents and information with people outside the organization, thus extending the automated business processes to include external participants?


Options are :

  • Process Reporting
  • Process Integrator
  • Forms Builder
  • Process Builder

Answer : Process Integrator

Which statement about the DQL WHERE clause is true?


Options are :

  • It specifies which object properties should be retrieved.
  • It specifies the order in which search results should be returned.
  • It may contain logical operators such as AND, OR, or NOT.
  • .It indicates which Documentum repository should be searched.

Answer : It may contain logical operators such as AND, OR, or NOT.

Which character precedes an alias value?


Options are :

  • !
  • @
  • %
  • *

Answer : %

How must auditing be configured to facilitate process reporting?


Options are :

  • Auditing must be configured through the initiate process form.
  • Auditing must be configured on the process template.
  • Auditing must be configured using Documentum Administrator.
  • Auditing must be configured on the process instance.

Answer : Auditing must be configured on the process template.

E20-011 Storage Networking Design Management Practice Exam Set 3

Which statement about DQL is true?


Options are :

  • DQL can retrieve and update objects in a Documentum repository, but cannot create or delete them.
  • DQL can process and manipulate object content in a Documentum repository.
  • DQL can import documents into a Documentum repository from any JSR-170-compliant content management system.
  • DQL can be used to migrate standard objects to lightweight objects.

Answer : DQL can be used to migrate standard objects to lightweight objects.

A repository has objects of dm_document type in a folder named “SOPNet”. A user wants to find all dm_document in this folder AND all containing subfolders checked out by them.How can the user complete the following query to accomplish this?select * from dm_document where r_lock_owner=user _______________


Options are :

  • and folder(/SOPNet, all)
  • and folder(/SOPNet, *)
  • and folder(/SOPNet, descend)
  • and folder(/SOPNet)

Answer : and folder(/SOPNet, descend)

A user wants to determine how many folders and cabinets are linked to a document named "testdoc".Which query will do this?


Options are :

  • select count(r_link_cnt) from dm_document where object_name = 'testdoc'
  • select count(i_reference_cnt) from dm_document where object_name = 'testdoc'
  • select count(i_folder_id) from dm_document where object_name = 'testdoc'
  • select count(*) from dm_document where object_name = 'testdoc'

Answer : select count(i_folder_id) from dm_document where object_name = 'testdoc'

Which form of the "FROM" clause will search only the current version of the "SOP" type?


Options are :

  • SOP (ALL)
  • SOP (CURRENT)
  • CURRENT SOP
  • SOP

Answer : SOP

What can be referenced as an alias?


Options are :

  • Adm_note object
  • An accessor in a permission set
  • An object_id
  • Arepository owner

Answer : An accessor in a permission set

Which change is permitted during modification of a custom attribute in Composer?


Options are :

  • Change the datatype from Numeric to String.
  • Change a custom attribute’s name.
  • Decrease the length of a String datatype.
  • Increase the length of a String datatype.

Answer : Increase the length of a String datatype.

E10-110 Enterprise Content Management Certify Practice Exam Set 1

Which statement about Composer Projects is true?


Options are :

  • Composer Projects can be versioned.
  • Composer Projects can be uninstalled from the repository
  • Composer Projects have the same characteristics as Virtual Documents.
  • Composer Projects can be archived into DAR files

Answer : Composer Projects can be archived into DAR files

What is the only required component of an alias reference?


Options are :

  • alias_set_name
  • alias_name
  • substitution_variable
  • alias_name.alias_set_name

Answer : alias_name

Which properties of the dm_document objects are returned by the following DQL query?Select * from dm_document, the *


Options are :

  • All read/write single and repeating-valued properties
  • All read/write single and repeating-valued properties, r_object_id, r_object_type, r_creation_date, r_modify_date, and a_content_type
  • All read/write single-valued properties only
  • All read/write single-valued properties, r_object_id, r_object_type, r_creation_date, r_modify_date, and a_content_type

Answer : All read/write single-valued properties, r_object_id, r_object_type, r_creation_date, r_modify_date, and a_content_type

Which activity requires the content that is sent to it to be a well-formed XML file that is namespace self-sufficient?


Options are :

  • database write
  • jms inbound
  • Web service
  • jms outbound

Answer : Web service

Which statement about DQL is true?


Options are :

  • DQL is a compiled language that executes faster than SQL on Oracle databases.
  • DQL requires a user to have at least Browse permission to view property values for a repository object by DQL.
  • DQL is a scripted language used to customize Documentum client user interfaces.
  • DQL is a more precise language than SQL and therefore returns a more precise set of results.

Answer : DQL requires a user to have at least Browse permission to view property values for a repository object by DQL.

Which DQL statement is used to modify an object type?


Options are :

  • ALTER TYPE
  • MODIFY
  • SET OBJECT
  • MODIFY TYPE

Answer : ALTER TYPE

E20-011 Storage Networking Design Management Practice Exam Set 1

A user wants to search for a document whose subject is set to “server” or “Server”.Which DQL query will do this?


Options are :

  • select object_name from dm_document where subject like '%erver'
  • select object_name from dm_document where subject like '?erver'
  • select object_name from dm_document where lower(subject) = 'server'
  • select object_name from dm_document where lower(subject) = 'Server'

Answer : select object_name from dm_document where lower(subject) = 'server'

What CANNOT be included in a Composer Project?


Options are :

  • Group
  • Aspect
  • Lifecycle
  • Server Config Object

Answer : Server Config Object

What happens when a Composer Project is installed in a repository?


Options are :

  • Project artifacts will be deployed.
  • Existing projects are uninstalled.
  • The repository config object is updated.
  • Existing repository objects are overwritten

Answer : Project artifacts will be deployed.

What is a benefit to using Permission Set Templates?


Options are :

  • The overall number of required Permission Sets is reduced.
  • System performance is enhanced.
  • Accessor assignment accuracy is ensured.
  • Custom Permission Sets are eliminated.

Answer : The overall number of required Permission Sets is reduced.

A user wants to write a DQL query that can be run on a daily basis to determine which documents were modified since the start of the previous day.How should the following query be completed to achieve this result? selectobject_name from dm_document _____


Options are :

  • where r_change_date>date(yesterday)
  • where r_change_date>= date(yesterday)
  • where r_modify_date>= date(yesterday)
  • where r_modify_date>date(yesterday)

Answer : where r_modify_date>= date(yesterday)

A user wants a list of documents with keywords that contain the words 'parent,' 'child' or both 'parent' and 'child.'How should the following query be completed to achieve this result? selectobject_name from dm_document __________


Options are :

  • Where any keywords='parent' or keywords='child'
  • Where any keywords='parent' and keywords='child'
  • Where any keywords='parent' and any keywords='child'
  • Where any keywords='parent' or any keywords='child'

Answer : Where any keywords='parent' or any keywords='child'

E20-002 Cloud Infrastructure and Services Practice Exam Set 2

What is required to make a filtered report on process data available?


Options are :

  • A process template must be configured with user inputs
  • The ability to specify search criteria must be limited to the workflow supervisor.
  • The user must input search criteria while viewing the report.
  • Predefined user inputs must be configured

Answer : The user must input search criteria while viewing the report.

What does a Template ACL contain?


Options are :

  • Accessors
  • Custom Permission Sets
  • Aliases
  • Templates

Answer : Aliases

A folder named "inner" resides in the cabinet named "outer."How should a user complete the following query to list all objects directly inside the "inner" folder?selectobject_name from dm_sysobject _____


Options are :

  • where folder_path = '/outer/inner'
  • where cabinet('/outer') and folder(/inner)
  • where folder('/outer/inner')
  • where cabinet('/outer/inner')

Answer : where folder('/outer/inner')

What is the purpose of a Composer DAR file?


Options are :

  • To package and deploy projects
  • To control source code
  • To organize projects
  • To track and identify artifacts

Answer : To package and deploy projects

Which DQL element is used to identify the object type and RDBMS tables to retrieve from a Documentum repository?


Options are :

  • FROM
  • WHERE
  • SELECT
  • PROPERTIES

Answer : FROM

Where are Composer Projects stored?


Options are :

  • A .ZIP file
  • Repository /System cabinet
  • Composer workspace
  • Application Server

Answer : Composer workspace

E20-002 Cloud Infrastructure and Services Practice Exam Set 4

An external table has been registered using this DQL statement:REGISTER TABLE airports_table (airport_nameSTRING(256), airport_code STRING(3)) Which DQL statement will return the airport_code for John F. Kennedy Airport?


Options are :

  • SELECT airport_code_table FROM airport_code name = “John F. Kennedy Airport”
  • SELECT airport_code FROM airports_table WHERE airport_name = 'John F. Kennedy Airport'
  • SELECT airport_code FROM dm_airports_table WHERE airport_name = 'John F. Kennedy Airport'
  • SELECT airport_code FROM airport_code_table. airport_name = 'John F. Kennedy Airport'

Answer : SELECT airport_code FROM airports_table WHERE airport_name = 'John F. Kennedy Airport'

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions