Your Customer wants to fetch specific contact details using an ROQL query. Their requirements are:
1. Fetch Contact ID, Contact First name, and Contact Last name details.
2. Contact first name should start with "A."
3. Query should run against the report database.
4. All contacts must be sorted in ascending order by Contact first name.
Which query will meet all the requirements?

• A. String queryString = "USE OPERATIONAL; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE
• B. Name.First like 'A%* ORDER BY Contact.Name.First;
• C. String queryString = "USE REPORT; SELECT id, C.First, C.Last FROM Contact C WHERE C.First tike *A%' ORDER BY Contact.First;
• D. String queryString = "USE REPORT; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First like 'A%' ORDER BY Contact.Name.First;
• E. String queryString « "USE REPORT; SELECT id. C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First = 'A%' ORDER BY Contact.Name.First;

Your client wants to create three themes: gold, silver, and bronze.
Which three actions will allow the themes to be set dynamically through the URL?

• A. Create custom widget that will, among other things, call the setTheme ( ) method.
• B. Create themes in mapping.php by using the <m:theme> page tag.
• C. Create the post_page_render hook.
• D. Create custom controller that will, among other things, call the setTheme ( ) method.
• E. Create a custom model that will, among other things, call the setTheme ( ) method.
• F. Create the pre_page_r@nder hook.
• G. Define themes in the template by using the <rn:theme> page tag.

A developer is writing code on the Ask a Question page to redirect users to the login form if they are not already logged in. Which is the correct rn tag to implement this logic?
A)

B)

C)

D)

E)

• A. Option A
• B. Option C
• C. Option E
• D. Option B
• E. Option D

A developer wants to see the SimpleSearch widget only under the answers folder pages. Which is the correct code to implement it in the standard template?
A)

B)

C)

D)

E)

• A. Option A
• B. Option C
• C. Option E
• D. Option B
• E. Option D