CRT-402 Practice Test

At Universal Containers, the VP of Service has requested a visual indicator flag on each case, based on the case priority. High-priority cases should be flagged red, medium-priorityshould be flagged yellow, and
low-priority cases should be flagged green. Which formula would accomplish this requirement? Choose 2
answers

A.

CASE( Priority, “Low”, “img/samples/flag_green.gif”, “Medium”, “img/samples/flag_yellow.gif”,
“High”, “img/samples/flag_red.gif”, “/s.gif”)

B.

IMAGE( IF(ISPICKVAL(Priority, “Low”), “img/samples/flag_green.gif”, IF(ISPICKVAL(Priority,
“Medium”), “img/samples/flag_yellow.gif”, IF(ISPICKVAL(Priority, “High”),
“img/samples/flag_red.gif”))), “Priority Flag”)

C.

IF(ISPICKVAL(Priority, “Low”), “img/samples/flag_green.gif”, IF(ISPICKVAL(Priority, “Medium”),
“img/samples/flag_yellow.gif”, IF(ISPICKVAL(Priority, “High”), “img/samples/flag_red.gif”,
“/s.gif”)))

D.

IMAGE(CASE( Priority, “Low”, “img/samples/flag_green.gif”, “Medium”,
“img/samples/flag_yellow.gif”, “High”, “img/samples/flag_red.gif”, “Priority Flag”)

What the true statement is in regards to converting a tabular, summary, or matrix report to a joined report? Choose 3 answers

A.

Joined report blocks are formatted as matrix reports.

B.

Bucket fields are not supported in joined reports.

C.

Cross filters are not supported in joined reports

D.

The rows to display filter is not supported in Joined reports

E.

Report formula fields are nor supported in Joined reports

The director of marketing has asked the app builder to create a formula field that tracks how many days have
elapsed since a contact was sent a marketing communication. The director is only interested in whole units.
Which function should be used to calculate the difference?

A.

Datevalue()

B.

Now()

C.

Date()

D.

Today()

What is the capability of schema Builder? Choose 2 Answers

A.

Showing selected objects on the page.

B.

Editing custom settings

C.

Viewing page layout in a new window

D.

Creating a new recordtype

A junction object has two Master-Detail relationships. What happens to a junction object record when either associated master record is deleted?

A.

The record is deleted and placed in the recycle bin.

B.

The master record can’t be deleted if it has a child record.

C.

The look-up field on the junction object record is cleared.

D.

The record is permanently deleted and can’t be restored.