EMC Legato Cert E20-120 Questions & Answers

• Question 41:

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

  A. select object_name from dm_document where subject like '%erver'

  B. select object_name from dm_document where subject = 'Server'

  C. select object_name from dm_document where upper(subject) = 'SERVER'

  D. select object_name from dm_document where upper(subject) = 'Server'

  Correct Answer: C

• Question 42:

  Which DQL statement shows the different versions of a document named "Q3 Report"?

  A. SELECT * FROM dm_document (ALL) WHERE object_name = 'Q3 Report'

  B. SELECT * (ALL) FROM dm_document WHERE object_name = 'Q3 Report'

  C. SELECT * FROM dm_document WHERE object_name = 'Q3 Report' (ALL)

  D. SELECT * FROM dm_document (ALL) WHERE object_name = 'Q3 Report' AND ANY r_version_label = 'ALL'

  Correct Answer: A

• Question 43:

  A user wants a list of all folders and subfolders within the Resources cabinet in a repository.

  How should the user complete the following query to accomplish this?

  select object_name from dm_folder _____

  A. where folder('/Resources')

  B. where folder = '/Resources'

  C. where folder('/Resources', descend)

  D. where folder = '/Resources', descend

  Correct Answer: C

• Question 44:

  A user has marked several documents for removal from a repository by setting the subject property of the documents to 'remove.' Which DQL statement will delete these documents?

  A. prune dm_document objects where subject = 'remove'

  B. remove dm_document objects where subject = 'remove'

  C. delete dm_document objects where subject = 'remove'

  D. destroy dm_document objects where subject = 'remove'

  Correct Answer: C

• Question 45:

  A user wants a list of documents with keywords that contain the words "interface," "class" or both "interface" and "class."

  How can the user complete the following query to accomplish this? select object_name from dm_document _____

  A. where any keywords='interface' or keywords='class'

  B. where any keywords='interface' and keywords='class'

  C. where any keywords='interface' or any keywords='class'

  D. where any keywords='interface' and any keywords='class'

  Correct Answer: C

• Question 46:

  A user wants to write a DQL query that can be run on a daily basis to determine which documents were

  modified on the previous day.

  How can the user complete the following query to accomplish this?

  select object_name from dm_document _____

  A. where r_modify_date = date(yesterday)

  B. where r_modify_date >= date(yesterday)

  C. where r_modify_date > date(yesterday) and r_modify_date < date(today)

  D. where r_modify_date >= date(yesterday) and r_modify_date < date(today)

  Correct Answer: D

• Question 47:

  A user wants to determine how many documents they own. Which query will do this?

  A. select count(*) from dm_document where owner_name = user

  B. select sum(*) from dm_document where owner_name = user

  C. select sum(r_link_cnt) from dm_document where owner_name = user

  D. select number_of(object_name) from dm_document where owner_name = user

  Correct Answer: A

• Question 48:

  Which DQL statement is correct for changing the title property of a document, named "Arch Diagram", to "Figure 1"?

  A. UPDATE dm_document SET title = 'Figure 1' WHERE object_name = 'Arch Diagram'

  B. ALTER dm_document OBJECT SET title = 'Figure 1' WHERE object_name = 'Arch Diagram'

  C. UPDATE dm_document OBJECT SET title = 'Figure 1' WHERE object_name = 'Arch Diagram'

  D. ALTER dm_document SET title = 'Figure 1' WHERE object_name = 'Arch Diagram'

  Correct Answer: C

• Question 49:

  When does the Content Server resolve an alias on a sysobject?

  A. every time the object is checked in

  B. the first time the object is checked in

  C. when the object's lifecycle state changes

  D. when the object is linked to a folder in the repository

  Correct Answer: B

• Question 50:

  What is a benefit of permission set templates?

  A. Folders that use permission set templates can be locked.

  B. Permission set templates eliminate the need for custom permission sets.

  C. Permission set templates allow enhanced permissions to be applied to an object.

  D. Users and groups referenced in a permission set template can be dynamically assigned.

  Correct Answer: D