Adobe ACE ColdFusion 9A0-127 Questions & Answers

• Question 31:

  You need to create an XML document inside your application from data in a query. Which function creates an XML document?

  A. xmlNew()

  B. xmlParse()

  C. xmlElemNew()

  D. toXml()

  Correct Answer: A

• Question 32:

  You have two instances of Art loaded within the ColdFusion ORM, and you want to modify their corresponding database records within a single atomic operation in the file workWithArt.cfm. What is the best way to accomplish this?

  A. use CFTRANSACTION within Art.cfc

  B. use CFLOCK within Art.cfc

  C. use CFTRANSACTION around the references to both instances within workWithArt.cfm

  D. use CFLOCK around the references to both instances within workWithArt.cfm

  Correct Answer: C

• Question 33:

  What is the name of the ColdFusion function that rolls back a transaction?

  A. transactionRollback()

  B. transRollback()

  C. rollBack()

  D. rollbackTransaction()

  Correct Answer: A

• Question 34:

  To which value should the access attribute of a CFC function be set, so the function is available only to CFCs in the same physical folder?

  A. private

  B. package

  C. public

  D. local

  Correct Answer: B

• Question 35:

  You are utilizing ORM in ColdFusion 9.

  Which tag should you use to map table fields to variables of the component?

  A. cfsetting

  B. cfproperty

  C. cfargument

  D. cfmapping

  Correct Answer: B

• Question 36:

  You want to allow Flash Remoting and web service clients to fetch all of the records from the Art table through the ColdFusion ORM, sorted by the artName field in ascending order. To perform this action, you create another CFC to act as a service layer, ArtService.cfc, and write a method named getAllArt.

  How should you write the method to retrieve the correct data and most accurately represent the type of that data?

  A. public Array function getAllArt() { return entityLoad("Art, {}, "artName ASC"); }

  B. remote Art[] function getAllArt() { return entityLoad("Art", {}, "artName ASC"); }

  C. remote Array function getAllArt() { return entityLoad("Art", {}, "artName ASC"); } records = arrayNew(1);

  D. remote Array function getAllArt() { records = entityLoad("Art", {}, "artName ASC"); }

  Correct Answer: B

• Question 37:

  You want to delete an Art entity from the ColdFusion ORM and from the database. The array of Art entities is stored within the array aArt, and the entity to be deleted is the second member of the array. The primary key property of the Art entity is artId.

  Which statement deletes this entity?

  A. arrayDeleteAt(aArt, 2);

  B. aArt[2] = null;

  C. entityDelete(aArt[2].artId);

  D. entityDelete(aArt[2]);

  Correct Answer: D

• Question 38:

  You want to use the script-based component Artist.cfc to represent entities within the table Artists in the datasource artGallery using the ColdFusion ORM.

  Which two changes must be made within Artist.cfc? (Choose two.)

  A. add persistent = "true" to the component declaration

  B. add table = "Artists" to the component declaration

  C. add persistent = "true" to the CFCOMPONENT tag

  D. add ormEnabled = "true" to the component declaration

  E. add entityName = "Artists" to the component declaration

  Correct Answer: AB

• Question 39:

  You have a database table named Art, which uses an automatically-incremented integer for the artId primary key column. You want to create a persistent Art component that provides a default value of zero for new Art instances that do not correspond to existing database records.

  Which statement is true about what must be done to accomplish this?

  A. Nothing needs to be done as it happens automatically.

  B. You cannot do anything at this time. You must explicitly set the value of artId when creating the new instance.

  C. You must add unsavedValue = "0" to the artId property.

  D. You must add default = "0" to the artId property.

  Correct Answer: C

• Question 40:

  You want to use the component Art.cfc to represent entities within the table Art in the datasource artGallery using the ColdFusion ORM. This datasource refers to a MySql database.

  What must you do in Application.cfc?

  A. set Application.ormEnabled = "true"

  B. set this.ormEnabled = "true"

  C. set this.dataSource = "artGallery"

  D. set this.ormSettings = {dialect="MySql", savemapping="true"}.

  Correct Answer: B