Tuesday, August 5, 2008

Oracle certifications

Oracle Certification Program Candidate Guide

Benefits of Oracle certifications

The demand for professionals in the information technology (IT) industry is high, and the competition for jobs is intense. Individuals, experienced or new to the profession, need to know what skills make them attractive to employers. Employers look for ways to select prospective employees who have the solid foundation of skills needed for effective performance.

The Oracle Certification Program helps the IT industry establish a standard of competence in key entry-level and professional job roles.

An Oracle Certification is a valuable, industry-recognized credential that signifies a proven level of knowledge and ability. Each higher level of Oracle certification brings a higher standard of benchmarked skill and ability, which leads to greater opportunities and higher pay.

"Technical certifications have evolved from a hiring tool to a screening tool: If you don’t have them, you aren’t viewed as a serious candidate." 1

Benefits to the Technical Professional

An Oracle Certified Associate (OCA) demonstrates a solid understanding of the foundation skills of a given job role, which can be applied at an apprentice or entry level.

By earning an OCA certification, you can have increased entry-level job opportunities. The OCA is the stepping-stone to starting a successful career as an Oracle professional.

Beyond OCA, by becoming an Oracle Certified Professional (OCP) you demonstrate your understanding of the full range of skills required by Oracle professionals in your chosen job role. An OCP is in high demand in today's marketplace, and the level of demand is expected to grow with each new installation of Oracle technologies around the world. An Oracle Certification helps raise your visibility and increases your access to the industry's most challenging opportunities.

"Oracle’s certification strength in a declining economy is due in part to the fact tha more complex, high-level certifications appear to be less vulnerable" 2t

An Oracle Certified Master (OCM) certification is the highest credential that an Oracle professional can earn in the Oracle Certification Program. An Oracle DBA Certified Master is a top-level Oracle expert who has in-depth technical knowledge of the Oracle data server and industry experience in managing mission-critical Oracle database systems and applications. OCMs are looked upon as experts within their organizations, among their peers, and across the industry.

The true value of earning an Oracle Certification credential is increased opportunity. With more opportunity come career growth and higher pay.

"Given the key importance of data as an organizational asset, it should come to no surprise that DBAs remain in high demand and that related training certification programs are popular even in this time of economic trouble... By the numbers, Oracle leads the DBMS/DBA certification area.” 3

Benefits to the IT Employer

The Oracle Certification Program is also valuable to hiring managers who want to distinguish among candidates for critical IT positions. For companies that send employees for annual IT training, certification helps ensure a return on the training investment by validating the knowledge and understanding gained during training sessions. Companies can also combine certification with an employee development program to enhance employee loyalty and performance on the job. Hiring certified professionals can have a direct impact on a company's success.

1 Source: Employers Raise the Bar on Certification, Information Week, 2002

2 Source: IDC Certification Report and Forecast 2002–2006

3 Source: Certified Expert: Working as a Database Administrator, CertMag, January 2003

Oracle9i DBA Certification Overview

The expertise of Oracle database administrators (DBAs) is integral to the success of today's increasingly complex system environments. Their critical work requires a broad understanding of the architecture and processes of the Oracle database, as well as plenty of hands-on experience in solving problems. The best DBAs know that they stand between optimal performance and an event that could bring their company to a standstill.

“Currently, Oracle skills remain the most sought-after database skills in the IT marketplace.” 1

Oracle9i Database Administrator Certified Associate (OCA)

An Oracle9i Database Administrator Certified Associate (OCA) certification is an entry-level credential for candidates who have a proven foundation of basic knowledge, which they can build upon as they work toward a career as an Oracle database administrator. An OCA can next earn Oracle9i DBA Certified Professional (OCP) and Oracle9i DBA Certified Master (OCM) credentials.

Oracle9i Database Administrator Certified Professional (OCP)

By moving upward and earning OCP status, Oracle professionals demonstrate the complete set of skills that are required for working independently as an expert DBA. The OCP credential provides candidates increased opportunities and higher pay. The OCP DBA path requires four tests two for OCA certification plus two more. Additionally, Oracle now requires (as of September 1, 2002) all newly starting OCP candidates to complete one Oracle University hands-on course in preparation for their exams and for future roles as an Oracle technologist. An OCP certification helps you translate your knowledge and skills into increased visibility through the market's most highly valued database benchmark program.

View the chart on page 5 for a list of required tests and course requirements to earn the Oracle9i Database OCP credential.

Oracle9i DBA Certified Master (OCM)

Beyond OCP, highly experienced DBAs who are ready for a new challenge can earn the highly respected Oracle9i DBA Certified Master (OCM) credential, which can help their careers develop further and open doors to senior DBA and consulting opportunities. The Oracle9i DBA Certified Master Program requires Oracle University coursework on advanced DBA topics and hands-on demonstration of DBA skills in a live application environment. For more information about this offering, consult the Oracle Certification Program Web site.

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 3

Upgrading Your Current OCP Credential to Oracle9i

Single Release Upgrade Exams

Generally, one exam is required for OCPs to upgrade to each new release of an Oracle DBA track. For example, one exam upgrades the Oracle7.3 credential to Oracle8, one exam from Oracle8 to Oracle8i, one exam from Oracle8i to Oracle9i and one exam from Oracle9i to Oracle 10g.

Oracle7.3 to Oracle8 DBA OCP

Exam #1Z0-010 Oracle8: New Features for Administrators.

Oracle8 to Oracle8i DBA OCP

Exam #1Z0-020 Oracle8i: New Features for Administrators.

Oracle8i to Oracle9i DBA OCP

Exam #1Z0-030 Oracle9i Database: New Features for Administrators.

Bridged Release Upgrade Exams

OCPs with older credentials may skip intervening releases and upgrade to a current technology with a single exam. For example, one exam upgrades Oracle7.3 and Oracle8 DBAs directly to Oracle9i, and one exam upgrades Oracle8i DBAs directly to Oracle Database 10g.

Oracle7.3 and Oracle8 DBA OCPs to Oracle9i

Exam #1Z0-035 Oracle9i DBA: New Features for Oracle7.3 and Oracle8 OCPs.

Candidate Qualifications

Most candidates for DBA certification combine up-to-date training with some level of on-the-job experience. There is no "typical" candidate. Many of the questions on the OCP tests are based on real job scenarios. In addition to the appropriate training, you need hands-on experience with the software. Trial software versions and hands-on labs are included in most Oracle University training products.

1 Source: IDC Certification Report 2002

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 4

Required Exams and Selected Hands-On Courses for Oracle9i Database Certification Paths

Oracle customers and business partners demand hands-on experience—with all aspects of Oracle database—from their Oracle Certified Professionals. In order to meet our commitments to our customers and constituents, Oracle University has recently made a significant investment toward building more validity and quality into its Certification Program including scenario-based exam questions.

Exams Required

Oracle9i Database Administrator Certified Associate Oracle9i Database Administrator Certified Professional

Oracle9i Database: Fundamentals I

Exam # 1Z0-031

Oracle9iDatabase Administrator Certified Associate

Oracle9iDatabase: Fundamentals II

Exam # 1Z0-032

Introduction to Oracle: SQL®

Exam # 1Z0-007

Introduction to Oracle: SQL® and PL/SQLExam # 1Z0-001

OR

Exam # 1Z0-007

Introduction to Oracle9i: SQL can be taken over the Internet; (see Section 5 of this guide).

Oracle9i Database: Performance Tuning

Exam # 1Z0-033

Oracle9iDatabase Administrator Certified Professional

Oracle University Hands-On Course Requirement

To earn your Oracle9i Certified Professional credential, you must pass the exams listed above and complete one of the selected Oracle University courses listed below.

Note the additional courses that have been added to the list of those that fulfil the Oracle9i DBA OCP Hands-On Course Requirement. Beginning June 21, 2004 candidates may now attend any one of the courses below to meet the requirement.

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 5

Current OCP Candidates Tested BEFORE September 1, 2002

OCP candidates who have already completed at least one exam toward earning their OCP credential before September 1, 2002, will be permitted to earn their OCP credential without having to complete one of the hands-on courses listed above.

New OCP Candidates Tested AFTER September 1, 2002

All new OCP candidates will continue to be permitted to enroll in the required exams before fulfilling the hands-on course requirement, but will not be certified until completing both the exams and course requirement.

Note that candidates must first complete the OCA certification before obtaining an OCP credential.

OAI, OIA, and Workforce Development Students

Note that students completing their Oracle study with an Oracle Academic Initiative (OAI) program, Oracle Internet Academy (OIA), or an Oracle Workforce Development school do NOT need to complete one of the specific courses listed on the previous page, since these students are already completing this curriculum with their program of study.

Certified OCP DBAs

Currently certified OCP DBAs are not required to complete any additional hands-on courses; they are required only to pass the upgrade exam.

The courses listed on the previous page are offered at Oracle University centers around the world as well as at many Oracle Authorized Education Centers, and Oracle Authorized Education Partners. Instructor-led courses are also now available online, enabling candidates to complete this requirement from their home or office if travel or time is a constraint.

To find more information about these courses, or to enroll, visit the Oracle University Web site at http://www.oracle.com/education/ and select the Oracle9i DBA Learning Path.

* This title is not available online.

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 6

Oracle9i Database Upgrade Certification Paths

Follow the paths in the diagram below to upgrade your current Oracle DBA OCP credential.

Oracle9i Database Certified Master Certification Path

Follow the path in the diagram below to earn your Oracle9i DBA Certified Master credential.

Oracle7.3 Database Administrator Certified Professional

Oracle9i New Features for Administrators

Exam # 1Z0-030

Oracle9iDBA New Features for Oracle7.3 and Oracle8 OCPs

Exam # 1Z0-035

Oracle8i Database Administrator Certified Professional

Oracle8 New Features for Administrators

Exam # 1Z0-010

Oracle8 Database Administrator Certified Professional

Oracle8i New Features for Administrators

Exam # 1Z0-020

Oracle9iDatabase Administrator Certified Professional

Oracle9iDatabase Master Practicum (details are on page 11 of this guide)

Oracle9i Database Administrator Certified Professional

Attend two of the selected advanced OU courses listed on page 10 of this guide.

Oracle9iDatabase Administrator Certified Master

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 7

Oracle9i Database Administrator Certified Master Requirements

To earn your Oracle9i Database Administrator Certified Master credential, you must meet the following requirements.

Oracle9i DBA Certified Master (OCM)

An OCM certification is the highest credential that an Oracle professional can earn in the Oracle Certification Program. An Oracle9i Database Administrator Certified Master is a top-level Oracle expert who has in-depth technical knowledge of the Oracle data server and industry experience in managing mission-critical Oracle database systems and applications. OCMs are looked upon as experts within their organizations, among their peers, and across the industry.

Oracle9i Database OCM Practicum

To earn the Oracle9i Database Administrator Certified Master credential, candidates must pass the practicum exam.

The Oracle9i DBA Certified Master practicum is a two-day live application event where participants are required to complete a series of scenarios and resolve technical problems that will test their expertise in an Oracle9i Database environment. Participants are scored on their ability to successfully complete the assigned tasks.

The practicum is conducted at an Oracle University facility in each global region. Contact your local Oracle University representative to find the Practicum location nearest you. Visit http://www.oracle.com/education/contact_info.html to view your local Oracle University contact information.

Practicum Registration Prerequisites

Prior to registering for the Oracle Certified Master practicum, candidates must complete two requirements.

1. They must have completed their Oracle9i Database Administrator Certified Professional (OCP) credential.

2. They must have taken two advanced DBA courses from Oracle University. Advanced courses are taught by top Oracle University instructors and offer hands-on experience in topics that may be addressed during the practicum. Advanced courses that are offered in an instructor-led online format satisfy the requirement for candidacy to the OCM.

The following is a list of Oracle University courses that meet the advanced course requirement.

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 8

Oracle9i Database OCM Practicum Course Prerequisite

The OCM Practicum candidates must attend two of the following courses listed below.

January 2005 - Oracle Certification Program Candidate Guide: Oracle9i Database Administrator Certified Associate, Professional, and Master Paths 9

Oracle9i DBA Certified Master Practicum

An OCM candidate must successfully pass the Oracle9i DBA Certified Master practicum after completing the required OU advanced learning requirements listed on the previous page.

Minimum Practicum Participant Skills

1. Proficiency in Oracle9i SQL

2. Working knowledge of Linux command language (United Linux 1.0) including:

a. Formatting and executing basic OS commands

b. Creating directories and navigating through directory structures

c. File management using copy, move, and delete

d. Linux environment text editors

e. Setting environment variables

3. Ability to locate and launch Oracle executables that include:

a. RMAN utility

b. Oracle Net Manager

c. Oracle Net Configuration Assistant

d. OEM

e. Listener utility

f. OMS

g. Oracle Password utility

h. Database Creation Assistant

4. Proficiency in using Oracle Enterprise Manager

5. Proficiency in using Oracle Net Manager and Oracle Net Configuration Assistant to configure networking

6. Advanced knowledge and use of Oracle9i (v9.0.1.3) Enterprise Server technology and features

7. Familiarity with navigating through online Oracle documentation

8. Proficiency in using Konqueror 2.2 browser software

Practicum Environment

The practicum is conducted in a dedicated Oracle University classroom environment. An Oracle instructor is responsible for proctoring the event, distributing scenarios, and collecting results. Participants are randomly assigned a seat on the day of the event.

Participants are not allowed to use personal documentation or notes during the practicum nor are they permitted to collaborate with other participants. Cellular phones, pagers, and Personal Digital Assistants are not allowed in the practicum classroom.

Each participant is provided with a dedicated Linux server with Advanced Server 2.1 installed and the base Oracle server software. A complete online Oracle documentation set is available to each participant.

Scoring

Participants are scored on their ability to complete the assigned tasks and to recover from various database failure scenarios. Information from each participant's environment is collected at various points during the practicum, and this information is used to determine the final score. Participants will be provided with their score within two weeks of completing the practicum. Upon attaining a successful score, participants are awarded the Oracle9i Database Administrator Certified Master credential. Participants who do not achieve a passing score are required to retake the entire practicum at a later date.

Practicum Objectives and Areas of Focus

Review the Oracle9i Database Administrator Certified Master practicum objectives to gain insight into what to expect before completing the practicum. The objectives are located in the Test Content Checklist at the end of this guide.

Software Quality Assurance Certifications

The functionality of Software Quality Assurance is to assure that the standards, processes, and procedures are appropriate for the project and are correctly implemented.

This is a process, which flows from software requirement Analysis, software design, coding, source code control, product testing, code reviews, change management, configuration management, and release management.

SQA comes in many forms, from the developer who tests the own code, and SQA testers work with automated testing tools and manual testing. Many vendors and groups have recognized Quality Assurance and Testing as an essential part of the development and maintenance process and have developed certifications to standardize and demonstrate knowledge of the QA process and testing tools.

SQA Certifications standardized by the Quality Assurance Institute (QAI) includes following levels of Certifications.

Certified Software Quality Analyst (CSQA),

Certified Software Tester (CSTE)

Certified Manager of Software Testing (CMST)

Certified Manager of Software Quality (CMSQ)

Certified Software Project Manager (CSPM)

Acquiring the above levels of certifications indicates a professional level of competence in the principles and practices of quality assurance in the IT profession and gains recognition as software quality profession, achieve more rapid career advancement, and gain greater acceptance in the role as advisor to management.

Discussing about new trends in software testing can be forced on testing tools and new methodologies in testing as the companies are trying hard to keep up a good demand by delivering reliable, bug-free, and quality software.

Continuous Integration (CI) is one such software testing trend that is quickly being adopted into the testing arena. It is a practice where the team members integrate their work with rest of the development team on a frequent basis. The development team and the testing team commit their changes to a central versioning system.

With CI the integration between the developed code and testing can be done as soon as the changes by developers get committed. This results in many integrations per day, as the development team will not have to wait for long to get feedbacks from the team of testers. CI would result in removing the code duplication, authenticity of dependencies, and coding standards.

Using the correct testing tool at the right time in a project can significantly increase the efficiency of testing by automating processes, increasing communication, promoting best practices and re-use of tests and test data.

The leading functional automated testing tools include:

Mecury: QTP and WinRunner

QuickTest Professional™ (QTP) and Mercury WinRunner® deliver a complete solution for functional test, GUI test, and regression test automation with support for practically every software application and environment.

Compuware: TestPartner and QARun

When testing complex applications based on Microsoft, Java and web-based technologies, TestPartner helps reassure that testing efforts are complete. For other application types, QARun gives developers and testers the automation capabilities needed to create and execute test scripts, verify tests and analyze test results.

IBM Rational Robot

IBM Rational Robot is a general purpose test automation tool for QA teams who want to perform functional testing of client/server applications.

Odin Technology - Axe

Axe is a new class of business process-oriented tools that allow non-technical users to automate testing. It provides a means to rapidly deploy automated testing systems that can be used by staff without specialist automation skills and minimal training. This reduces the cost of introducing and maintaining test automation by a factor of four. Axe can translate scripts to run with any of the functional testing tools mentioned above.

These are the leading automated testing tools for functional and regression testing. As well as functional regression testing tools there are also automated performance testing tools

Monday, August 4, 2008

SIEBEL 7 Consultant Core Certification Exam


Topic Coverage

The Siebel 7 Consultant Core Exam will include the topics listed below. The approximate

percentage of the exam that will be dedicated to each topic is indicated below. These topics

are drawn from the Siebel 7 Essentials Course, and the questions on the exam will test

knowledge and skills gained by completing and studying the course materials.

Topic % of Exam

1 Foundations 16%

2 Architecture and Installation 11%

3 Access Control & Organizational Setup 11%

4 Exploring Siebel Applications 8%

5 Configuration 28%

6 Data Loads 4%

7 Business Process Automation 9%

8 Deployment 13%

Exam Objectives

The Siebel 7 Consultant Core Exam will be based on the following objectives. These

objectives represent the knowledge and skills gained from the Siebel 7 Essentials Course.

Siebel 7 Consultant Core Exam

1 Foundations

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 1: Introducing Siebel 7

Define the Siebel eBusiness Enterprise as An integrated product suite that helps manage customer

relationships.

Identify and define the five Siebel business entities (Accounts, Opportunities, Contacts, Service

Requests, and Activities).

Identify and define the three application types (Employee, Customer, and Partner).

Classify Siebel products by their application type.

Module 2: Using the Siebel Client

Describe and navigate the Siebel user interface (UI).

Module 3: Organizing Data Behind the User Interface

Describe how data is organized behind the user interface (UI).

Describe the relationship between database data and data in the UI.

Describe the relationship between lists, forms, views, business components, and business objects.

Siebel 7 Consultant Core Exam

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

Siebel eConfigurator, ePricer, and eAdvisor are collectively known as what?

A. Siebel MidMarket Edition

B. Interactive Selling Suite

C. Siebel Employee Applications

D. Siebel Sales

The correct answer is B.

Interactive Selling Suite is a collection of Siebel eBusiness Applications. eConfigurator,

ePricer, eSales, eAdvisor, and eAuction are all components of the Siebel Interactive Selling

Suite (ISS).

References:

Siebel 7 Essentials, “Introducing Siebel eBusiness Applications”

Siebel 7 Bookshelf, “Siebel Interactive Suite Upgrade Guide”

Question 2

Which entity represents a person external to your company?

A. Customer

B. Party

C. Contact

D. Person

The correct answer is C.

A Contact is a person with whom you do business, and is external to your company.

Reference:

Siebel 7 Essentials, “Introducing Siebel eBusiness Applications”

Siebel 7 Consultant Core Exam

Page 6 of 83

Question 3

Which entities always belong to a team? Choose three.

A. Activity

B. Opportunity

C. Contact

D. Account

E. Service Request

The correct answer is B, C & D.

Activities and Service Requests are assigned to specific employees. Opportunities,

Contacts, and Accounts are assigned to teams.

Reference:

Siebel 7 Essentials, “Introducing Siebel eBusiness Applications”

Question 4

Which type of product is an internal application used by employees and partners?

A. Employee Application

B. Partner Application

C. Customer Application

D. Employee Partner Application

The correct answer is A.

Employee applications, such as Siebel Sales, Siebel Call Center, and eFinance are internal

applications used by employees and partners.

Reference:

Siebel 7 Essentials, “Introducing Siebel eBusiness Applications”

Siebel 7 Consultant Core Exam

Page 7 of 83

Question 5

An Employee Application has the following characteristics? Choose two.

A. Used by employees only

B. Used by employees and partners

C. Internal application

D. Used by employees and customers

The correct answer is B & C.

Employee applications, such as Siebel Sales, Siebel Call Center, and eFinance are internal

applications used by employees and partners.

Reference:

Siebel 7 Essentials, “Introducing Siebel eBusiness Applications”

Question 6

Marcel found out the area code of his contact, Céline, has changed from 912 to 440. Which

of the following is the easiest way for him to change Céline’s area code?

A. Find Céline’s record in the My Contacts View, delete it, and create a new record

B. Find Céline’s record in the My Contacts View, go to the detail applet, change the

area code

C. Find Céline’s record in the All Contacts Across Organizations View, delete her

phone number from a primary list, and input the new one

D. Find Céline’s record in the My Contacts View, delete her phone number from a

primary list, and then input the new number

The correct answer is B.

To modify and save data, select the record field in the list or form and change it. The change

is saved when you click off of the record.

Reference:

Siebel 7 Essentials, “Using the Siebel Client”

Siebel 7 Consultant Core Exam

Page 8 of 83

Question 7

Which of the following objects is used to retrieve data from the database?

A. View

B. Business Object

C. Business Component

D. Database table

The correct answer is C.

Business Components are collections of data pulled from the database that reflect the user’s

business. A view is a collection of related lists and forms representing a business area. A

Business Object organizes business components in relationship to each other so related

data can be displayed in a view. A database table stores data in the database.

Reference:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Question 8

How many Business Components can a single list or form Applet reference?

A. Two (if using a toggle)

B. One

C. Unlimited

D. Eight

The correct answer is B.

Each Applet is based on a single Business Component.

References:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 9 of 83

Question 9

Complete this statement: A business object contains information about the _________

between business components.

A. Differences

B. Similarities

C. Shared properties

D. Relationships

The correct answer is D.

A business object contains information about the relationships between business

components. Business objects represent a collection of business components and the

relationship between them.

Reference:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Question 10

Which of the following statements is true?

A. Form applet data comes from only one table

B. Form applet data may come from many tables and columns

C. Form applet data may come from many columns in a single table

D. Form applet data comes from only one column in a table

The correct answer is B.

Data presented in a form applet may come from multiple tables and columns as an applet is

based on a single business component, which is a collection of data from tables and

columns.

References:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 10 of 83

Question 11

Complete the following statement. A set of related applets may be displayed in a

__________.

A. Business object

B. View

C. Screen

D. Business component

The correct answer is B.

A view is a collection of related lists and forms representing a functional business area.

References:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 12

Which applet type may simultaneously display more than one record?

A. List

B. Form

C. Child

D. Detail

The correct answer is A.

A list is able to display multiple records. A form shows detail of a single record.

References:

Siebel 7 Essentials, “Organizing Data Behind the User Interface”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

2 Architecture and Installation

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 4: Exploring the Siebel Architecture

Identify the components of the Siebel Web Architecture.

Describe the role of each component of the Siebel Web Architecture.

Define ODBC and how it is used within the Siebel Web Architecture.

Define the Siebel Web Engine and how it constructs the User Interface.

Summarize what happens when a user enters a URL for a Siebel application into a Web browser.

Module 5: Siebel Client Access

Identify the four types of clients deployed in Internet/intranet environments.

Identify the connectivity used for each client type.

Identify the application components required to execute a Siebel application.

Explain the role of each of the application components (.exe, .srf, & .cfg).

Summarize disconnected processing and how/when it may be used.

Recognize the most appropriate deployment plan for a given scenario.

Module 6: Installing Siebel Software

Identify and describe the pre-installation tasks (prepare for install, create OS accounts, create Siebel

DB, and create file system directory).

Identify the purpose for the Siebel Service Owner Account and the Siebel Monitoring Account.

Recognize the correct process for creating the Siebel Database.

Recognize the correct process for creating the Siebel File System.

Recognize the correct process for installing and verifying the gateway server.

Recognize the correct process for installing and verifying the enterprise and Siebel servers.

Recognize the correct process for installing and verifying the Siebel Database Server.

Recognize the correct process for installing the Siebel Web Server Extension.

Module 7: Server Administration

Explain how Server Manager enables you to perform server administration duties required for your

Siebel application.

Siebel 7 Consultant Core Exam

Page 12 of 83

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

On a Mobile Web Client using disconnected processing, how is HTML delivered to the

browser?

A. The HTML is pulled from the Web cache on the Mobile Web Client

B. It is not possible for a disconnected client to receive Siebel HTML pages

C. The local Web Server with SWSE delivers the HTML to the browser

D. The Mobile Web Client must synchronize to receive the HTML from the Siebel

Web Engine

The correct answer is C.

Disconnected processing refers to handheld and mobile Web client processing which has no

connection to a Siebel Server or database server. The local Web server with Siebel Web

Server Extensions delivers HTML to the browser.

References:

Siebel 7 Essentials, “How clients Access Siebel Data”

Siebel 7 Bookshelf, “Siebel Handheld Administration Guide for Palm OS”

Siebel 7 Consultant Core Exam

Page 13 of 83

Question 2

Refer to the exhibit below.

Scenario: You have three server machines and you are using desktop machines as clients.

You want to install full functionality for the Web client. Which components must be present

to support this functionality. Choose three.

A. Siebel Server

B. Siebel Web Engine

C. Gateway Server

D. Siebel Templates

E. Web Server

The correct answer is A, C & E.

The Web server and extensions should be on the first server. The next server should

include the Gateway server and Siebel server in this scenario.

References:

Siebel 7 Essentials, “How clients Access Siebel Data”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Consultant Core Exam

Page 14 of 83

Question 3

Refer to the exhibit below.

Scenario: You have two server machines and you are using laptops as clients for users who

will be traveling. You want to install full functionality for remote users. Which components

must be present to support this functionality. Choose three.

A. Siebel Web Server Extension

B. Object Manager

C. Siebel Web Engine

D. Data Manager

E. Eapps.cfg file

The correct answer is B, C & D.

The laptop will need the Data Manager and Object Manager as well as the first server in this

scenario. The Siebel Web Engine must also reside on both the server and laptop.

References:

Siebel 7 Essentials, “How clients Access Siebel Data”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for UNIX”

Siebel 7 Consultant Core Exam

Page 15 of 83

Question 4

What is the purpose of the Siebel Monitoring Account?

A. Used to monitor database capacity and alert DBA when approaching designated

thresholds

B. Used to run Enterprise Server processes and components

C. Required to run Windows processes or start UNIX daemons

D. Required by Resonate Central Dispatch connection brokering software

The correct answer is D.

This account is required for the Resonate Central Dispatch connection brokering server.

Therefore, you need this account only if you install connection brokering. Both the Resonate

manager account and the Resonate monitoring account must exist on each host on which

Central Dispatch has been installed.

Reference:

Siebel 7 Essentials, “Installing Siebel Software”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for UNIX”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Oracle Applications”

Siebel 7 Consultant Core Exam

Page 16 of 83

Question 5

Which of the following is NOT a valid task when installing and verifying the Enterprise and

Siebel Servers?

A. Invoke the installation program and follow the installation steps

B. Run the install.ksh script

C. Verify that the Windows Service and Unix daemon process is started

D. Inspect the SESsetup.log file in the Siebel root directory

The correct answer is B.

The install.ksh script is not used during installation of Enterprise and Siebel servers.

References:

Siebel 7 Essentials, “Installing Siebel Software”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for UNIX”

Question 6

How might you verify repository data after installing the Database Server?

A. View the SESsetup.log file in the Siebel root directory

B. Verify that the Windows Service and Unix daemon process is started

C. Run the imprep.ksh script

D. Run a query to count the records in the S_VIEW table

The correct answer is D.

Running a query against a repository table such as S_VIEW is a great way to verify that the

Database Server installation was successful.

References:

Siebel 7 Essentials, “Installing Siebel Software”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for UNIX”

Siebel 7 Consultant Core Exam

Page 17 of 83

Question 7

What function does the Siebel Web Engine perform when it receives a URL with a Siebel

request?

A. Gathers templates and data and builds an HTML page

B. Displays the HTML page on the client’s computer

C. Provides access to, and distributes load for Siebel Servers

D. Verifies that the client is using an acceptable browser

The correct answer is A.

The Web server recognizes that a URL contains a Siebel request and passes it to the Siebel

Web Engine. The Siebel Web Engine then builds the HTML page with data and template

tags which is passed via the Web server to the browser.

References:

Siebel 7 Essentials, “Exploring the Siebel Architecture”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Question 8

What happens when a user enters a URL for a Siebel application into a Web browser?

A. The Browser retrieves the appropriate templates and the Siebel Web Engine

retrieves the data from the database to build the HTML page

B. The Siebel Web Engine recognizes the URL and passes it to the Web Server

where the HTML page is built for the user

C. The Web Server retrieves the appropriate templates and the Siebel Web Engine

retrieves the data from the database to build the HTML page

D. The Web Server recognizes the URL and passes it to the Siebel Web Engine

where the HTML page is built for the user

The correct answer is D.

The Web server recognizes that a URL contains a Siebel request and passes it to the Siebel

Web Engine. The Siebel Web Engine then builds the HTML page with data and template

tags which is passed via the Web server to the browser.

References:

Siebel 7 Essentials, “Exploring the Siebel Architecture”

Siebel 7 Bookshelf, “Siebel Server Installation Guide for Microsoft Windows”

Siebel 7 Consultant Core Exam

3 Access Control & Organizational Setup

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 8: Access Control and Views

Identify the different types of users and relate them to the access they require.

Define Responsibility and how it is used to control view access.

Summarize the process for associating views to a responsibility.

Summarize the process for assigning users to responsibilities.

Distinguish between user responsibility and manager responsibility.

Analyze and identify the solution to the problem of a user having no access to a view.

Module 9: Access Control and Data

Describe and recognize examples of customer data.

Explain how users are granted access to customer data.

Describe the role of organization, position, and login in accessing customer data.

Distinguish between single, multiple, and sub organizations.

Describe the relationship between positions and teams.

Define primary position and the privileges associated with it.

Describe how primary position affects login.

Describe personal ownership and how it affects data presented in views.

Describe the relationship between Login ID and Personal Ownership.

Module 10: Access Control and View Types

Identify the independent relationship between view access and data access.

Identify the different view types used to accommodate the Access Control needs of different users.

Module 11: Creating an Organization

Describe the process of defining a company's organizational hierarchy.

Module 12: Authenticating Users

Distinguish between authentication and access control.

Describe internal authentication and external authentication, and how each works.

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

Ken Fisher has several positions, including Service Representative, Service Leader, and

Support Engineer. His primary position is Support Engineer. How should Ken change his

position to Service Representative after he logs in?

A. Change the default position flag in his profile

B. Select User Administration ? User Profile

C. Select the position during the login process

D. Select View ? User Preferences ? Change Position

The correct answer is D.

Users can only log into one position at a time, and that position defaults to the user’s

primary position. A user may change positions after logging on by selecting View ? User

Preferences ? Change Position.

Reference:

Siebel 7 Essentials, “Access Control and Data”

Siebel 7 Bookshelf, “Applications Administration Guide”

Question 2

Limiting data displayed in the My Service Request view to service requests assigned to the

user is an example of what?

A. Team-based access control

B. Access based on responsibility

C. Position-based access control

D. Access based on User ID

The correct answer is D.

Access to “My” views is an example of Personal Access Control. Typically, you can

implement personal access control when data has a creator or a person is assigned to the

data, usually as the owner.

References:

Siebel 7 Essentials, “Access Control and Data”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Question 3

A user’s User ID affects which of the following?

A. Access to data that the user created

B. Ability to forecast opportunities

C. Access to specific screens

D. Access to specific views

The correct answer is A.

Access based on User ID is Personal Access Control. Typically, you can implement

personal access control when data has a creator or a person is assigned to the data, usually

as the owner.

References:

Siebel 7 Essentials, “Access Control and Data”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 21 of 83

Question 4

Which of the following statements is true about access control?

A. Different users with the same Responsibility may see different data on the same

view

B. View access for a Responsibility in one Organization will be different in another

Organization

C. Users see data based on Responsibility, ID, and Position

D. Users with different view access cannot view the same data

The correct answer is A.

Even though users with the same responsibility have access to the same views, the data

contained in those views may be different based on other Access Control mechanisms.

References:

Siebel 7 Essentials, “Access Control and View Types”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Question 5

Which of the following views displays data based on a user’s position on a team and allows

all users associated with assigned positions to access the data?

A. My View

B. My Team’s View

C. All Across Organization View

D. All View

The correct answer is A.

The word “My” is frequently used in the titles of views applying single position access

control. However, “My” does not always imply single position access control. Some “My”

views apply personal, organization-based, or position-based sales team access control. For

example, the My Activities view applies personal access control.

References:

Siebel 7 Essentials, “Access Control and View Types”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 22 of 83

Question 6

When setting up your Organizational Hierarchy, why would you want to create a division

and then set the Organization Flag?

A. Making a division an organization prevents the assignment of records that

typically will be visible only to that organization

B. Because you want to remove the Division, but create an Organization with the

same name

C. You want other organizations to have access to the data

D. You do not want another organization to access the data

The correct answer is D.

When selected, the Organization Flag indicates that the division is also an organization. The system

copies that division into the Organization view.

References:

Siebel 7 Essentials, “Creating an Organization”

Siebel 7 Bookshelf, “Applications Administration Guide”

Question 7

You would navigate to the User Administration ? Employees screen to do which of the

following? Choose two.

A. Assign the user to views

B. Assign views to responsibilities

C. Adjust the user’s access to data records

D. Determine which responsibilities are assigned to a user

The correct answer is C & D.

By navigating to User Administration ? Employees, you are able to see the Responsibilities

and Positions assigned to the user. By making modifications on this screen, you can adjust

the user’s access to data records.

References:

Siebel 7 Essentials, “Access Control and Data”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 23 of 83

Question 8

Which access control mechanism would typically be used to ensure that Sales

Representatives in the UK have access to only UK Customer information?

A. Position

B. Responsibility

C. Personal

D. Organization

The correct answer is D.

When individual data can be associated with an organization, you can apply organizationbased

access control to the data. This limits data access to users assigned to a particular

organization.

References:

Siebel 7 Essentials, “Access Control and Data”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

4 Exploring Siebel Applications

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 13: Understanding Object Definitions Behind a Siebel Application

Describe each type of Object Definition (UI, Business, and Data object definitions) and the relationship

between them.

Describe the relationships between Object Definitions.

Module 14: Using Siebel Tools to Examine Object Definitions

Explain the use of Tools to examine parent and child object definitions.

Describe methods for locating object definitions in Tools by performing a search.

Module 15: Understanding the Siebel Data Model

Explain the roles of the primary and foreign keys, indexes and user keys, and how each impacts

performance.

Describe how to find foreign keys for a given relationship.

Module 16: Understanding the Siebel Data Model: Party Business Components

Identify the tables used to store Person and Organization data.

Describe the S_PARTY table, its extensions, and how it is used.

Siebel 7 Consultant Core Exam

Page 25 of 83

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

Which of the following is a valid relationship between Controls and Fields?

A. One control maps to many fields

B. Many controls map to one field

C. Many controls map to many fields

D. One control maps to one field

The correct answer is D.

A control object identifies individual data controls in the data entry form, such as text boxes

and command buttons. A control either corresponds to one field in the business component,

or invokes program logic (in the case of a button control).

References:

Siebel 7 Essentials, “Understanding Object Definitions Behind a Siebel Application”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 2

Upon completing a repository search in Tools, how do you navigate to an object definition

found during the search?

A. Right-click the object in the results list

B. Click the object in the results list

C. Double-click the object in the results list

D. Select the object and press the Space Bar

The correct answer is C.

Access the object definition by double-clicking the name of the object definition in the

Repository Search results list.

References:

Siebel 7 Essentials, “Using Siebel Tools to Examine Object Definitions”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 26 of 83

Question 3

What mechanism prevents the entry of duplicate records by specifying the columns that

must contain a unique set of values?

A. Foreign key

B. Index

C. Primary key

D. User key

The correct answer is D.

User keys specify columns that must contain a unique set of values, prevent users from

entering duplicate records, and are used to determine uniqueness of records during data

import operations.

References:

Siebel 7 Essentials, “Understanding the Siebel Data Model”

Siebel 7 Bookshelf, “Object Types Reference”

Question 4

Which type of relationship requires an intersection table?

A. Many-to-One (M:1)

B. One-to-One (1:1)

C. Many-to-Many (M:M)

D. One-to-Many (1:M)

The correct answer is C.

Many-to-Many relationships are captured using foreign key table columns in a third table

called the intersection table.

References:

Siebel 7 Essentials, “Understanding the Siebel Data Model”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 27 of 83

Question 5

Where is main organization-related data stored in the Siebel database?

A. S_ORG_EXT table

B. S_ORGANIZATION

C. S_BU table

D. S_BUSINESS table

The correct answer is A.

The main organization-related business component data is stored in the S_ORG_EXT table.

S_BU may store some additional organization-related data, but is not the main table.

References:

Siebel 7 Essentials, “The Siebel Data Model: Party Business Components”

Siebel 7 Bookshelf, “Applications Administration Guide”

Question 6

When you create a join to a party table, the destination column must reference the _____

column in the joined table.

A. ROW_ID

B. PARTY_ID

C. BU_ID

D. PAR_ROW_ID

The correct answer is D.

Tables joined to the S_PARTY table have a column named PAR_ROW_ID that is related to

the ROW_ID column in the S_PARTY table.

References:

Siebel 7 Essentials, “The Siebel Data Model: Party Business Components”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

5 Configuration

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 17: The Configuration Process

Describe the configuration process.

Explain the process for setting up a Siebel developer environment.

Module 18: Managing Object Definitions

Define the role of projects in configuration.

Describe Checking Out, Checking In, and Locking projects and how each affects other developers.

Module 19: Editing and Compiling Object Definitions

Describe the process of creating and editing object definitions and purposes for doing so.

Describe the process of archiving object definitions and projects and the purposes for doing so.

Describe the process of compiling object definitions into a repository file and the purposes for doing

so.

Module 20: Understanding Siebel Template Files

Define the different types of Siebel Web Templates and their usage.

Describe Siebel tag syntax and the role of placeholders in templates when deploying Siebel Web

pages.

Describe how to register, associate, and bind a template, and the reasons for each.

Module 21: Configuring Applications and Screens

Describe the process for customizing the container page components including page and view tabs

and system menus.

Module 22: Configuring Views

Explain how to configure views to satisfy business requirements.

Describe the process for associating a view with a Web template.

Module 23: Configuring List Applets

Describe the process for configuring list applets to display company data.

Module 24: Configuring Form Applets

Describe the process for configuring form applets to display company data.

Module 25: Understanding Business Components and Joins

Describe the structure of business components and joins.

Describe how to map fields to columns in base, joined, and extension tables.

Describe how and when to create joins and join specifications to bring data in from a joined table.

Module 26: Understanding Business Components and Joins: Party Extension Tables

Describe the process and considerations for creating joins and join specifications involving an SPARTY

business component.

Module 27: Understanding Business Objects and Links

Describe the role of business objects and links and the process for creating them.

Module 28: Configuring Business Components and Fields

Explain the process for editing business component and field properties to capture business logic.

Module 29: Creating New Business Components Using Standard 1:M Extension Table

Describe how to incorporate additional business entities that don’t correspond to business

components in a standard Siebel application using 1:M extension tables.

Module 30: Configuring Navigation

Describe how to add drilldowns and toggles to assist users in navigating Siebel applications.

Describe how to activate the thread bar to assist users in navigating Siebel applications.

Module 31: Extending the Database

Describe the process and reasoning for creating extension columns in a table.

Describe the process and reasoning for creating custom extension tables (standalone, 1:1, 1:M,

Intersection).

Module 32: Configuring Picklists

Describe the process for configuring drop-down lists and pick lists.

Module 33: Configuring Multi-Value Groups

Describe how to use Siebel Tools to configure a multi-value field and multi-value link and why you

would do so.

Describe how to use Siebel Tools to configure a multi value group so users may select one or more

related child records and why you would do so.

Module 34: Configuring Access Control

Demonstrate the ability to ensure that your configured application displays the appropriate set of

records to each of your users.

Explain how visibility is configured for each type of view (Personal, Manager, All, and All across

organization).

Module 35: Localizing an Application

Describe the process and considerations for configuring your application for deployment in a

multinational environment.

Module 36: Configuration Guidelines

Identify the best configuration decisions based on performance implications and configuration best

practices for a successful implementation.

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

You want to add your company’s logo in the branding area. Which of the following is NOT a

step that you need to accomplish this?

A. Compile an .srf and test the application after you modify it in Tools to see

whether the logo appears

B. Specify the name of the logo in an HTML IMG tag

C. Test the application after saving the template file to see whether the logo appears

D. Edit CCFrameBanner.swt template file to add an image

The correct answer is A.

To change the logo in the Banner Frame, you would modify the template file to add the

image, providing the image file name in the HTML, then test the application.

References:

Siebel 7 Essentials, “Configuring Applications and Screens”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 32 of 83

Question 2

What steps do you have to perform in order to bind applets to a view template? Choose two.

A. Drag the applets from the list onto the placeholders in the view template

B. Launch the Web View Layout Editor in Siebel Tools to have the template file and

the applets window open

C. Create a new Screen View definition in Screens

D. Modify properties in Siebel Tools, by navigating to View ? View Web template ?

View Web Template Item

The correct answer is A & B.

Binding applets to a view template involves launching the Web View Layout Editor and

dragging the applets from the applet window to the applet placeholders in the Web View

Editor.

References:

Siebel 7 Essentials, “Configuring Views”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 3

Which of the following is true of the Item Identifier property of an applet web template item?

A. It is read by the Siebel Tools to generate the final HTML

B. It specifies the condition under which this item is mapped

C. It specifies the ID assigned to the control that is mapped to the placeholder in the

.swt file

D. It specifies the name of the control or list item such as List and Form

The correct answer is C.

The .SWT template files do not include references to specific controls in the repository.

Instead, they specify a layout and style, with placeholder tags. Other Siebel tags might place

other items, such as view bars, applets, or controls, for instance, in a Web Page.

References:

Siebel 7 Essentials, “Configuring Form Applets”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 33 of 83

Question 4

You want to edit the Web layout of a Contact Form applet by right-clicking and choosing

Edit Web Layout. You have checked out the appropriate project but you still get an error as

soon as you choose Edit Web Layout. Which of the following toolbar settings should you

have set first?

A. History

B. List

C. Web Controls

D. Edit

E. Target Browser Group

F. Debug

The correct answer is E.

The target browser group determines how conditional template tags are expressed in the

layout editor. Inside the template are SWE:IF tags that conditionally execute blocks of code.

At edit time you see the applet the way it would show up for the particular browser you have

chosen. At run time, the conditional sections in the template are executed appropriately for

the current browser.

References:

Siebel 7 Essentials, “Configuring Form Applets”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 34 of 83

Question 5

Opportunity and Sales Stage have a M:1 relationship according to your business model.

You want to show some data from the Sales Stage business component in your Opportunity

business component. How would you do this?

A. By creating an implicit join between the Opportunity business component and the

S_PARTY table

B. By using the intersection table S_OPTY_STG

C. By creating a link between Opportunity and Sales Stage business components

D. By creating a join from the Opportunity business component to the S_STG table

The correct answer is D.

A Join object definition creates a relationship between a business component and a table

other than its base table. The join allows the business component to use columns from that

table. The join uses a foreign key in the business component to obtain rows on a one-to-one

basis from the joined table, even though the two do not necessarily have a one-to-one

relationship.

References:

Siebel 7 Essentials, “Understanding Business Components and Joins”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 6

Which of the following is NOT true of the Join Specification object type?

A. Name of the join specification object definition must be unique within the join

B. Destination column is required if the join occurs on a column other than ROW_ID

C. Source field denotes the name of the field on which the destination table will be

joined

D. The Join Specification specifies the table to be joined

The correct answer is D.

Join Specification is a child object type of Join that provides details about how the join is

implemented within the business component.

References:

Siebel 7 Essentials, “Understanding Business Components and Joins”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 35 of 83

Question 7

You want to bring party data into a different party business component. Which of the

following would you NOT do when mapping a field to a column in a Party table?

A. Select an existing or create a new explicit join

B. Use the existing implicit join from S_PARTY to the other Party table

C. Set the appropriate type for the new Field

D. Select the desired column in the joined table

The correct answer is B.

You should not use the implicit join that already exists. Other party tables are extension

tables for S_PARTY. You must use an explicit join based on the appropriate foreign keys. It

will have a different alias.

References:

Siebel 7 Essentials, “Business Components and Joins: Party Extension Tables”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 8

In a M:M link, which of the following properties must be populated? Choose three.

A. Child business component

B. Inter table

C. Destination field

D. Inter child column

The correct answer is A, B & D.

The Destination field is used in a 1:M link. In a M:M link, the Inter Table property identified

the intersection table. The Child Business Component property identifies the child in the

relationship and the Inter Child Column property identifies the Foreign key column in the

intersection table for the child table that is linked to the foreign key column in the intersection

table for the parent table (identified in the Inter Parent Column property).

References:

Siebel 7 Essentials, “Understanding Business Objects and Links”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 36 of 83

Question 9

When you configure a static drilldown to a different business component, which of the

following you would NOT do? Choose two.

A. Set Hyperlink field and view properties

B. Set business component, source field, and destination field properties to enable

drilldown to a view based on a different parent record

C. Create a new drilldown object for the applet in Siebel Tools

D. Identify one or more matching conditions to trigger drilling down to a specific

target view

E. Set the field, value, and sequence properties

The correct answer is D & E.

To configure a static drilldown to a different business component, you create a new

drilldown object for the applet, set the hyperlink field and View properties, and set the

Business Component, Source Field, and Destination Field properties.

References:

Siebel 7 Essentials, “Configuring Navigation”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Bookshelf, “Object Types Reference”

Siebel 7 Consultant Core Exam

Page 37 of 83

Question 10

Which of the following is NOT one of the steps in configuring a dynamic picklist in Siebel

Tools?

A. Set the Type Value property on the picklist to the picklist name in the

S_LST_OF_VAL

B. Specify the Business Component to be used by the Pick List object

C. Set the runtime property to TRUE on the control or list column object

D. Create a Pick Map definition

The correct answer is A.

The S_LST_OF_VAL table is used for static picklists, not dynamic picklists. A dynamic

picklist draws values from a business component with records edited by users. Values

displayed in a dynamic picklist can change during runtime.

References:

Siebel 7 Essentials, “Configuring Picklists”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 11

Which of the following are true of Multi-value group (MVG)? Choose two.

A. Its visual cue is

B. It requires dedicated space for each child record on a view

C. Multi-value field is required for an MVG

D. It is an alternative to a detail view for managing parent and related child records

E. It cannot be built on M:M relationships

The correct answer is C & D.

A multi-value group (MVG) applet is a dialog box that provides the means to display and

maintain a set of records of data from another business component (child) associated with

the currently displayed business component (parent) record. The multi-value field is a field in

the parent business component that references a field in the child business component.

References:

Siebel 7 Essentials, “Configuring Multi-Value Groups”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 38 of 83

Question 12

Which of the following is a valid reason to use unused columns of an existing standard 1:1

extension table (rather than creating a custom extension column on the base table)?

A. The columns will very rarely be included in the User Interface, and applies to only

a small subset of the records in the base table

B. It will improve performance

C. It is a solution when you have not purchased the Advanced Database

Extensibility module

D. Siebel does not permit creation of new columns on base tables

The correct answer is A.

Adding a field that references a column in a standard 1:1 extension table may result in some

performance degradation associated with the join. However, if that field is displayed on an

applet that is not frequently used, then the performance impact is slight.

References:

Siebel 7 Essentials, “Extending the Database”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 13

Which of the following access control mechanisms is NOT how Siebel limits records a user

can access in a given view?

A. Membership in access groups for catalogs and categories

B. User ID

C. User’s responsibilities

D. User’s organization

E. User’s position

The correct answer is C.

Responsibility determines which views the user can see, but does not control the data that is

presented in that view.

References:

Siebel 7 Essentials, “Configuring Access Control”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 39 of 83

Question 14

Which of the following is NOT one of the steps of enabling Multilingual List of Values

(MLOVs)?

A. Compile a new .srf and deploy

B. Determine which columns to enable

C. Update the existing data in the database by running the MLOV upgrade utility

D. Configure columns for MLOVs

E. Create 1:M extension table to S_LST_OF_VAL table for each target language

The correct answer is E.

To enable a multi-lingual list of values, you determine the columns to enable, configure the

columns, add translated values to the LOV table, update existing data in the database, and

compile a new .srf file and deploy.

References:

Siebel 7 Essentials, “Localizing an Application”

Siebel 7 Bookshelf, “Global Deployment Guide”

Question 15

For which Contact view do you set the Visibility Applet Type property to Sales Rep?

A. For All Contacts

B. For My Team’s Contacts

C. For My Personal Contacts

D. For All Contacts across Organizations

E. For My Contacts

The correct answer is E.

“My” views are configured by setting the Visibility Applet property to identify an applet in the

view and setting the Visibility Applet Type property to Sales Rep. The Visibility Applet Type

property will default to Sale Rep if this property is left blank.

References:

Siebel 7 Essentials, “Configuring Access Control”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 40 of 83

Question 16

Which of the following BusComp View Modes would you set to have My Team's View?

Choose two.

A. Set Visibility Field to Owned By Id

B. Set BusComp Popup Visibility Type to Sales Rep

C. Set Owner Type to Position

D. Set BusComp Visibility MVField to Sales Rep

E. Set View Visibility Applet Type Name to Personal

The correct answer is C & D.

The “My Team’s” views are Manager Views and are configured by setting the Visibility

Applet property to identify an applet in the view and setting the Visibility Applet Type

property to Manager. Additionally, the Owner type must be Position or Personal.

References:

Siebel 7 Essentials, “Configuring Access Control”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Question 17

You would like to see Siebel Actuate Reports in Portuguese instead of English. Which of

the following would you use?

A. Regional setting

B. Internationalization

C. Language specific compilation

D. Localization

The correct answer is D.

Localization refers to the process of adapting a program to a specific locale. Siebel

applications can be localized by translating and resizing elements of the user interface such

as dialog boxes, buttons, error messages, reports, and online help.

References:

Siebel 7 Essentials, “Localizing an Application”

Siebel 7 Bookshelf, “Global Deployment Guide”

Siebel 7 Consultant Core Exam

Page 41 of 83

Question 18

What is the effect of checking out a project? Choose three.

A. Locks the project in the server repository but not in the local repository

B. Locks the projects in the local database repository

C. Locks the projects in the server database repository

D. Copies all object definitions in the project on the server to the local database

The correct answer is B, C & D.

Checking out a project locks the project in both the local database repository and the server

database repository. Checking out a project also copies all of the object definitions in the

project to the local database.

References:

Siebel 7 Essentials, “Managing Object Definitions”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 19

Which of the following populates a newly-initialized local database with a read-only copy of

all projects in the server repository?

A. Database Extract

B. Get

C. Checking Out

D. Checking In

The correct answer is B.

You need to do an initial Get before doing the first compile for your local repository— your

.srf files must be based on the full list of delivered Siebel object definitions plus any changes

you make. You can also use a full get to refresh read-only projects in an existing local

repository.

References:

Siebel 7 Essentials, “Managing Object Definitions”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 42 of 83

Question 20

To modify the Siebel application what would you do?

A. Modify the application engine that reads the repository file

B. Write custom stored procedures against the repository file

C. Write SQL statements against the repository file

D. Edit object definitions that make up the repository file

The correct answer is D.

You will never modify the application engine. The only way you should modify the Siebel

application is through editing the object definitions that make up the repository file.

References:

Siebel 7 Essentials, “Editing and Compiling Object Definitions”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Question 21

Which of the following is NOT how you create a Web page in Siebel?

A. Its layout is edited in Siebel Tools

B. Once configured properly, a browser automatically replaces Siebel tags with

Siebel data

C. An applet is associated with a Web template object

D. A web template file is registered in a repository

The correct answer is B.

To create a Web page in Siebel applications, you will register the template, associate an

applet with the template object, and modify its layout in Tools.

References:

Siebel 7 Essentials, “Understanding Siebel Template Files”

Siebel 7 Bookshelf, “Siebel Tools Reference, Volume 1 of 2”

Siebel 7 Consultant Core Exam

Page 43 of 83

6 Data Loads

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 37: Introducing Enterprise Integration Manager

Describe how ROW_IDs support Siebel referential integrity.

Describe how Enterprise Integration Manager (EIM) is used to support Siebel referential integrity while

importing external data.

Module 38: Data Mapping

Describe the process and considerations for constructing a strategy for successful imports into and

deletes from the Siebel database.

Module 39: Running Enterprise Integration Manager

Describe the process and considerations for successfully importing external data into the Siebel

database and performing batch deletes.

Module 40: Setting EIM Options

Describe strategies and tasks for reducing time spent importing data, troubleshooting import problems,

and leveraging the full capabilities of EIM.

Module 41: Access Control and Access Groups

Explain how master data is organized into catalogs and categories.

Describe how you would control access to master data by associating access groups to categories.

Siebel 7 Consultant Core Exam

Page 44 of 83

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

How can you limit catalog visibility to only those groups associated with the catalog?

A. Adjust the responsibilities associated with the Access Groups to ensure only the

appropriate people have access

B. Set the Visible Flag for the catalog on the Catalog screen

C. Set the Private Flag for the catalog on the Catalog screen

D. Adjust the positions associated with the Access Groups to ensure only the

appropriate people have access

The correct answer is C.

For a catalog and all of its categories to be visible only to the access groups associated with

it, the catalog’s Private flag must be set.

References:

Siebel 7 Essentials, “Access Control and Access Groups”

Siebel 7 Bookshelf, “Authentication and Access Control Administration Guide”

Siebel 7 Consultant Core Exam

Page 45 of 83

Question 2

Why would you use the ONLY BASE TABLES parameter in your EIM configuration files?

A. To eliminate duplicate data

B. To verify import success

C. To speed up processing

D. To truncate EIM tables after import

The correct answer is C.

To explicitly include or exclude tables and columns to avoid unnecessary processing, use

ONLY BASE TABLES, ONLY BASE COLUMNS, IGNORE BASE TABLES, or IGNORE

BASE COLUMNS in your .ifb file.

References:

Siebel 7 Essentials, “Setting Enterprise Integration Manager Options”

Siebel 7 Bookshelf, “Siebel Enterprise Integration Manager Administration Guide”

Question 3

Which of the following are valid methods for verifying the success of an EIM task? Choose

three.

A. Use the client application to view data

B. Print the contents of the base tables and compare against legacy printouts

C. View Server Manager logs for EIM tasks

D. Use SQL SELECT statements against the EIM and base tables

The correct answer is A, C & D.

You can verify that your EIM task was successful by examining the Server Manager logs,

accessing the data in the application, or by running SQL SELECT statements against the

affected tables.

References:

Siebel 7 Essentials, “Invoking Enterprise Integration Manager”

Siebel 7 Bookshelf, “Siebel Enterprise Integration Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 46 of 83

7 Business Process Automation

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 42: Introducing Siebel Workflow

Describe the different steps of a workflow process.

Explain the steps involved in creating and testing a workflow process.

Module 43: Invoking Workflow Processes

Identify the different mechanisms for invoking a workflow process.

Module 44: Additional Workflow Topics

Describe workflow features (Import and Export, Versioning, Workflow Persistence, Process

Monitoring, and State Model).

Module 45: Introducing Assignment Manager

Describe Siebel Assignment Manager and the elements used by Assignment Manager to assign tasks

appropriately.

Module 46: Creating Sales Assignment Rules

Module 47: Creating Service Assignment Rules

Describe the process for creating Sales and Service Assignment Rules and the differences between

them.

Module 48: Invoking Assignment Manager

Identify the different mechanisms for invoking Assignment Manager.

Module 49: Personalizing View and Applet Access

Describe how to use personalization to meet the specific, individual needs of customers, partners, and

employees.

Describe the use of the Business Rule Designer to create personalization expressions.

Module 50: Personalizing Content and Behavior

Explain how and why to use rule sets to provide users with personalized content in applets.

Explain how to control system behavior with events and actions based on user profile attributes.

Siebel 7 Consultant Core Exam

Page 47 of 83

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

You have a Workflow process that evaluates the age of Service Requests and updates the

priority of Service Requests that are more than a week old. Which Siebel Workflow step

type are you using to change the priority of the Service Request?

A. Siebel Update step

B. Siebel Operation step

C. Decision Point step

D. Sub Process step

The correct answer is B.

Siebel Operation steps handle Siebel database operations, such as insert or update.

References:

Siebel 7 Essentials, “Introducing Siebel Workflow”

Siebel 7 Bookshelf, “Siebel Workflow Administration Guide”

Siebel 7 Consultant Core Exam

Page 48 of 83

Question 2

Which Siebel feature enables you to automatically apply a discount to a customer’s order

when the customer adds both a printer and replacement ink cartridges to their online

shopping cart?

A. Siebel Workflow Policy Program

B. Action Sets

C. Siebel Assignment Manager

D. Rule Sets

The correct answer is B.

Action sets are groups of actions that are triggered by events. They are created in the Action

Sets view under the Runtime Events Administration screen.

References:

Siebel 7 Essentials, “Personalizing Content and Behavior”

Siebel 7 Bookshelf, “Personalization Administration Guide”

Question 3

You currently have a Siebel Operation step in a Workflow Process that updates SR priority

from Low to High. You now want the Sub Process step to change the priority to Very High

rather than High. How do you change this detail?

A. Double-click the Siebel Operation step in the Process Designer

B. Delete the step and replace it with a new Sub Process step

C. Right-click the Siebel Operation step in the Process Designer

D. Double-click the Sub Process step in the Process Designer

The correct answer is D.

Double-clicking the Sub Process step in the process designer allows you to modify the input

and output arguments for the step in the process.

References:

Siebel 7 Essentials, “Introducing Siebel Workflow”

Siebel 7 Bookshelf, “Siebel Workflow Administration Guide”

Siebel 7 Consultant Core Exam

Page 49 of 83

Question 4

Which of the following is an Enterprise Component Group that should be enabled prior to

running Siebel Workflow?

A. Workflow Process Batch Manager

B. Workflow Action Agent

C. Workflow Monitor Agent

D. Workflow Management

E. Workflow Process Manager

The correct answer is D.

The Workflow Management component group should be enabled prior to running Siebel

Workflow processes. The other options listed here are actually components within the

Workflow Management component group.

References:

Siebel 7 Essentials, “Invoking Workflow Processes”

Siebel 7 Bookshelf, “Siebel Workflow Administration Guide”

Question 5

Which of the following is NOT an option with Siebel Workflow’s Wait Step?

A. Pause a process for a specified amount of time

B. Pause a process until a specified runtime event occurs

C. Include a restart parameter in the process

D. Include a timeout parameter in the process

The correct answer is C.

The Wait Step allows you to pause a process for a specified amount of time, pause a

process until a specific runtime event occurs, and to include a timeout parameter in the

process.

References:

Siebel 7 Essentials, “Introducing Siebel Workflow”

Siebel 7 Bookshelf, “Siebel Workflow Administration Guide”

Siebel 7 Consultant Core Exam

Page 50 of 83

Question 6

If an applet has five associated Rule Sets, and the first three rule sets will not return any

data for the current user, but the last two rule sets will, how many rule sets are evaluated for

this user?

A. 4

B. 3

C. 2

D. 5

The correct answer is A.

Rule Sets are evaluated in sequence order. Evaluation stops when a rule set returns

content. If an applet has five associated rule sets and the first three will not return any data,

four rule sets are evaluated. The first three, plus the fourth, in order to return data for the

user.

References:

Siebel 7 Essentials, “Personalizing Content and Behavior”

Siebel 7 Bookshelf, “Personalization Administration Guide”

Question 7

How can you tell if your connectors in a Siebel Workflow process are successfully

connecting the steps as you create the Workflow process? Choose two.

A. The two ends of the connector will be white in color

B. By running the process using Process Simulator

C. By right-clicking the connector line

D. The two ends of the connector will be red in color

The correct answer is B & D.

When a connector is successfully connected, the end of the connector will be red. If you run

the process in the Process Simulator without error, you also know that the connectors are all

connected.

References:

Siebel 7 Essentials, “Introducing Siebel Workflow”

Siebel 7 Bookshelf, “Siebel Workflow Administration Guide”

Siebel 7 Consultant Core Exam

Page 51 of 83

8 Deployment

The tables below list the objectives covered by the Siebel 7 Consultant Core Exam. The first

row of each table indicates the eBusiness Essentials Module that objectives and exam

questions are based upon.

Module 51: Using Siebel Remote to Support Mobile Clients

Describe how activity is tracked on the server database and local database.

Explain the steps required to set up mobile clients.

Module 52: Additional Remote Topics

Describe how Siebel Remote identifies and resolves database conflicts.

Describe mobile client maintenance and ways to manage synchronization.

Module 53: Migrating Data Between Environments

Describe the process for migrating user data and migrating the Siebel application from a development

environment to a test environment.

Sample Exam Questions

The questions below represent the types of questions you will see on the Siebel 7

Consultant Core Exam. Beneath each question is an explanation and cross-reference to

training materials.

Question 1

Which of the following describes .dx files?

A. Transaction files transferred between the Server and Mobile Client

B. Temporary files that are automatically purged upon application exit

C. Directory files used by Siebel to organize physical file directories

D. Log files used for troubleshooting EIM process errors

The correct answer is A.

The .dx files are compressed, sequentially numbered transaction files created by the

Transaction Router server task.

References:

Siebel 7 Essentials, “Using Siebel Remote to Support Mobile Clients”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 52 of 83

Question 2

What is stored in the S_DOCK_TXN_LOG table in the Server Database?

A. Before and after images of data

B. A list of transactions performed while docked

C. All of the data that is changed during a remote session

D. Remote user information

The correct answer is A.

Field level changes are tracked and stored in a master transaction table

(S_DOCK_TXN_LOG) as rows.

References:

Siebel 7 Essentials, “Using Siebel Remote to Support Mobile Clients”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Question 3

In the first time set up of mobile users, what must you do before data can be loaded in the

Mobile Client’s local database?

A. Run the dev2prod.ksh script

B. Create the database schema for the local database

C. Copy the Siebel Database file to the mobile client

D. Copy the .cfg and .srf file from the server to the mobile client machine

The correct answer is B.

In order to set up a mobile client, you must enable transaction logging, register the user as a

mobile client, create the schema for the local database, create the initial subset of data, and

initialize the local database.

References:

Siebel 7 Essentials, “Using Siebel Remote to Support Mobile Clients”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 53 of 83

Question 4

Which server task creates the Docking\User directory on the Siebel Server for a new Mobile

Client?

A. Transaction Router

B. Generate New Database

C. Synchronization Manager

D. Database Extract

The correct answer is D.

The Database Extract server task applies routing rules to server data to extract the

appropriate subset of data, creates a compressed .uaf file, and creates the Docking\User

directory on the Siebel Server.

References:

Siebel 7 Essentials, “Using Siebel Remote to Support Mobile Clients”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Question 5

What does the Transaction Merger server task do when it encounters a Duplicate Conflict?

Choose two.

A. Merges the two records together into one record

B. Adds the duplicate record and sets a flag to indicate that duplicates exist

C. Does not add the duplicate record and logs the conflict in the remote status log

D. Notifies the mobile client of the duplicate

The correct answer is B & D.

Transaction Merger uses specific rules to resolve conflicts with database data changes. For

a Duplicates Conflict, Transaction Merger will add the duplicate record, but set a flag to

indicate that the duplicate exists. Transaction Merger will also notify the mobile client of the

duplicate.

References:

Siebel 7 Essentials, “Additional Siebel Remote Topics”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 54 of 83

Question 6

When does the Transaction Merger server task override the MRG: System Conflict

Resolution system preference?

A. Never

B. When a Duplicate Conflict occurs

C. When an Update Conflict occurs

D. When a Delete Conflict occurs

The correct answer is D.

Transaction Merger uses specific rules to resolve conflicts with database data changes.

When a Delete Conflict occurs, transaction Merger will override the MRG: System Conflict

Resolution system preference. Whether this preference is set to Client Wins or Server Wins,

a delete always wins.

References:

Siebel 7 Essentials, “Additional Siebel Remote Topics”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Question 7

What action is recommended if a mobile user is going to be unable to synchronize for an

extended period of time (leave of absence, for example)?

A. Change the synchronization frequency

B. Modify the views assigned to the mobile client

C. Set a new effective end-date for the mobile client to deactivate it

D. Remove the mobile client’s local database completely

The correct answer is C.

If a mobile client will not be able to connect for an extended period of time, it is usually best

to deactivate the mobile client and extract a new database when the mobile client returns

rather than attempt to synchronize the large number of transactions created while the mobile

client was away.

References:

Siebel 7 Essentials, “Additional Siebel Remote Topics”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 55 of 83

Question 8

When initially preparing your target environment for migration, which of the following tasks

should you complete? Choose three.

A. Check out projects that were changed in development

B. Create user accounts

C. Install any required client software

D. Install database and server software

E. Copy the .srf file to server and clients

The correct answer is C, D, & E.

To prepare your target environment, you need to install the database and server software,

install any required client software, copy the .srf and other client files to the sever and

necessary clients, and verify the parameters (.cfg, ODBC, etc.)

References:

Siebel 7 Essentials, “Migrating Data Between Environments”

Siebel 7 Bookshelf, “Siebel Enterprise Integration Manager Administration Guide”

Question 9

What is dataexp.exe used for when migrating environments?

A. To generate a data merge file that contains user and seed data

B. To create flat files containing data from non-EIM tables

C. To create flat files containing data from EIM tables

D. To generate a compressed copy of the source database

The correct answer is C.

Dataexp.exe extracts data from source EIM tables into flat files. Dataexp.exe cannot be

used against non-EIM tables because ROW_IDs will be different between the source and

target.

References:

Siebel 7 Essentials, “Migrating Data Between Environments”

Siebel 7 Consultant Core Exam

Page 56 of 83

Question 10

Which of the following must you do to reactivate a mobile client? Choose two.

A. Perform a database extract

B. Create the mobile client DOCKING sub-directory on the server

C. Add the server name to the DockConnString line of siebel.cfg

D. Remove the end date for the mobile client

The correct answer is A & D.

To reactivate a mobile client, you remove the end date and run a database extract for the

reinstated mobile client.

References:

Siebel 7 Essentials, “Additional Siebel Remote Topics”

Siebel 7 Bookshelf, “Siebel Remote and Replication Manager Administration Guide”

Siebel 7 Consultant Core Exam

Page 57 of 83

Practice Exam

1. Siebel eConfigurator, ePricer, and eAdvisor are collectively known as what?

A. Siebel MidMarket Edition

B. Interactive Selling Suite

C. Siebel Employee Applications

D. Siebel Sales

2. Which entity represents a person external to your company?

A. Customer

B. Party

C. Contact

D. Person

3. Which entities always belong to a team? Choose three.

A. Activity

B. Opportunity

C. Contact

D. Account

E. Service Request

Siebel 7 Consultant Core Exam

Page 58 of 83

4. Which type of product is an internal application used by employees and partners?

A. Employee Application

B. Partner Application

C. Customer Application

D. Employee Partner Application

5. An Employee Application has the following characteristics? Choose two.

A. Used by employees only

B. Used by employees and partners

C. Internal application

D. Used by employees and customers

6. Marcel found out the area code of his contact, Céline, has changed from 912 to 440. Which

of the following is the easiest way for him to change Céline’s area code?

A. Find Céline’s record in the My Contacts View, delete it, and create a new record

B. Find Céline’s record in the My Contacts View, go to the detail applet, change the

area code

C. Find Céline’s record in the All Contacts Across Organizations View, delete her

phone number from a primary list, and input the new one

D. Find Céline’s record in the My Contacts View, delete her phone number from a

primary list, and then input the new number

Siebel 7 Consultant Core Exam

Page 59 of 83

7. Which of the following objects is used to retrieve data from the database?

A. View

B. Business Object

C. Business Component

D. Database table

8. How many business components can a single list or form applet reference?

A. Two (if using a toggle)

B. One

C. Unlimited

D. Eight

9. Complete this statement: A business object contains information about the _________

between business components.

A. Differences

B. Similarities

C. Shared properties

D. Relationships

10. Which of the following statements is true?

A. Form applet data comes from only one table

B. Form applet data may come from many tables and columns

C. Form applet data may come from many columns in a single table

D. Form applet data comes from only one column in a table

Siebel 7 Consultant Core Exam

Page 60 of 83

11. Complete the following statement. A set of related applets may be displayed in a

__________.

A. Business object

B. View

C. Screen

D. Business component

12. Which applet type may simultaneously display more than one record?

A. List

B. Form

C. Child

D. Detail

13. On a Mobile Web Client using disconnected processing, how is HTML delivered to the

browser?

A. The HTML is pulled from the Web cache on the Mobile Web Client

B. It is not possible for a disconnected client to receive Siebel HTML pages

C. The local Web Server with SWSE delivers the HTML to the browser

D. The Mobile Web Client must synchronize to receive the HTML from the Siebel

Web Engine

Siebel 7 Consultant Core Exam

Page 61 of 83

14. Refer to the exhibit below.

Scenario: You have three server machines and you are using desktop machines as clients.

You want to install full functionality for the Web client.

Which components must be present to support this functionality. Choose three.

A. Siebel Server

B. Siebel Web Engine

C. Gateway Server

D. Siebel Templates

E. Web Server

Siebel 7 Consultant Core Exam

Page 62 of 83

15. Refer to the exhibit below.

Scenario: You have two server machines and you are using laptops as clients for users who

will be traveling. You want to install full functionality for remote users.

Which components must be present to support this functionality. Choose three.

A. Siebel Web Server Extension

B. Object Manager

C. Siebel Web Engine

D. Data Manager

E. Eapps.cfg file

Siebel 7 Consultant Core Exam

Page 63 of 83

16. What is the purpose of the Siebel Monitoring Account?

A. Used to monitor database capacity and alert DBA when approaching designated

thresholds

B. Used to run Enterprise Server processes and components

C. Required to run Windows processes or start UNIX daemons

D. Required by Resonate Central Dispatch connection brokering software

17. Which of the following is NOT a valid task when installing and verifying the Enterprise and

Siebel Servers?

A. Invoke the installation program and follow the installation steps

B. Run the install.ksh script

C. Verify that the Windows Service and Unix daemon process is started

D. Inspect the SESsetup.log file in the Siebel root directory

18. How might you verify repository data after installing the Database Server?

A. View the SESsetup.log file in the Siebel root directory

B. Verify that the Windows Service and Unix daemon process is started

C. Run the imprep.ksh script

D. Run a query to count the records in the S_VIEW table

Siebel 7 Consultant Core Exam

Page 64 of 83

19. What function does the Siebel Web Engine perform when it receives a URL with a Siebel

request?

A. Gathers templates and data and builds an HTML page

B. Displays the HTML page on the client’s computer

C. Provides access to, and distributes load for Siebel Servers

D. Verifies that the client is using an acceptable browser

20. What happens when a user enters a URL for a Siebel application into a Web browser?

A. The Browser retrieves the appropriate templates and the Siebel Web Engine

retrieves the data from the database to build the HTML page

B. The Siebel Web Engine recognizes the URL and passes it to the Web Server

where the HTML page is built for the user

C. The Web Server retrieves the appropriate templates and the Siebel Web Engine

retrieves the data from the database to build the HTML page

D. The Web Server recognizes the URL and passes it to the Siebel Web Engine

where the HTML page is built for the user

21. Ken Fisher has several positions, including Service Representative, Service Leader, and

Support Engineer. His primary position is Support Engineer. How should Ken change his

position to Service Representative after he logs in?

A. Change the default position flag in his profile

B. Select User Administration ? User Profile

C. Select the position during the login process

D. Select View ? User Preferences ? Change Position

Siebel 7 Consultant Core Exam

Page 65 of 83

22. Limiting data displayed in the My Service Request view to service requests assigned to the

user is an example of what?

A. Team-based access control

B. Access based on responsibility

C. Position-based access control

D. Access based on User ID

23. A user’s User ID affects which of the following?

A. Access to data that the user created

B. Ability to forecast opportunities

C. Access to specific screens

D. Access to specific views

24. Which of the following statements is true about access control?

A. Different users with the same Responsibility may see different data on the same

view

B. View access for a Responsibility in one Organization will be different in another

Organization

C. Users see data based on Responsibility, ID, and Position

D. Users with different view access cannot view the same data

Siebel 7 Consultant Core Exam

Page 66 of 83

25. Which of the following views displays data based on a user’s position on a team and allows

all users associated with assigned positions to access the data?

A. My View

B. My Team’s View

C. All Across Organization View

D. All View

26. When setting up your Organizational Hierarchy, why would you want to create a division and

then set the Organization Flag?

A. Making a division an organization prevents the assignment of records that typically

will be visible only to that organization

B. Because you want to remove the Division, but create an Organization with the

same name

C. You want other organizations to have access to the data

D. You do not want another organization to access the data

27. You would navigate to the User Administration ? Employees screen to do which of the

following? Choose two.

A. Assign the user to views

B. Assign views to responsibilities

C. Adjust the user’s access to data records

D. Determine which responsibilities are assigned to a user

Siebel 7 Consultant Core Exam

Page 67 of 83

28. Which access control mechanism would typically be used to ensure that Sales

Representatives in the UK have access to only UK Customer information?

A. Position

B. Responsibility

C. Personal

D. Organization

29. Which of the following is a valid relationship between Controls and Fields?

A. One control maps to many fields

B. Many controls map to one field

C. Many controls map to many fields

D. One control maps to one field

30. Upon completing a repository search in Tools, how do you navigate to an object definition

found during the search?

A. Right-click the object in the results list

B. Click the object in the results list

C. Double-click the object in the results list

D. Select the object and press the Space Bar

Siebel 7 Consultant Core Exam

Page 68 of 83

31. What mechanism prevents the entry of duplicate records by specifying the columns that

must contain a unique set of values?

A. Foreign key

B. Index

C. Primary key

D. User key

32. Which type of relationship requires an intersection table?

A. Many to One (M:1)

B. One to One (1:1)

C. Many to Many (M:M)

D. One to Many (1:M)

33. Where is main organization-related data stored in the Siebel database?

A. S_ORG_EXT table

B. S_ORGANIZATION

C. S_BU table

D. S_BUSINESS table

34. When you create a join to a party table, the destination column must reference the _____

column in the joined table.

A. ROW_ID

B. PARTY_ID

C. BU_ID

D. PAR_ROW_ID

Siebel 7 Consultant Core Exam

Page 69 of 83

35. You want to add your company’s logo in the branding area. Which of the following is NOT a

step that you need to accomplish this?

A. Compile an .srf and test the application after you modify it in Tools to see whether

the logo appears

B. Specify the name of the logo in an HTML IMG tag

C. Test the application after saving the template file to see whether the logo appears

D. Edit CCFrameBanner.swt template file to add an image

36. What steps do you have to perform in order to bind applets to a view template? Choose two.

A. Drag the applets from the list onto the placeholders in the view template

B. Launch the Web View Layout Editor in Siebel Tools to have the template file and

the applets window open

C. Create a new Screen View definition in Screens

D. Modify properties in Siebel Tools, by navigating to View ? View Web template ?

View Web Template Item

37. Which of the following is true of the Item Identifier property of an applet web template item?

A. It is read by the Siebel Tools to generate the final HTML

B. It specifies the condition under which this item is mapped

C. It specifies the ID assigned to the control that is mapped to the placeholder in the

.swt file

D. It specifies the name of the control or list item such as List, Form

Siebel 7 Consultant Core Exam

Page 70 of 83

38. You want to edit the Web layout of a Contact Form applet by right-clicking and choosing Edit

Web Layout. You have checked out the appropriate project but you still get an error as

soon as you choose Edit Web Layout. Which of the following toolbar settings should you

have set first?

A. History

B. List

C. Web Controls

D. Edit

E. Target Browser Group

F. Debug

39. Opportunity and Sales Stage have a M:1 relationship according to your business model.

You want to show some data from the Sales Stage business component in your Opportunity

business component. How would you do this?

A. By creating an implicit join between the Opportunity business component and the

S_PARTY table

B. By using the intersection table S_OPTY_STG

C. By creating a link between Opportunity and Sales Stage business components

D. By creating a join from the Opportunity business component to the S_STG table

40. Which of the following is NOT true of the Join Specification object type?

A. Name of the join specification object definition must be unique within the join

B. Destination column is required if the join occurs on a column other than ROW_ID

C. Source field denotes the name of the field on which the destination table will be

joined

D. The Join Specification specifies the table to be joined

Siebel 7 Consultant Core Exam

Page 71 of 83

41. You want to bring party data into a different party business component. Which of the

following would you NOT do when mapping a field to a column in a Party table?

A. Select an existing or create a new explicit join

B. Use the existing implicit join from S_PARTY to the other Party table

C. Set the appropriate type for the new Field

D. Select the desired column in the joined table

42. In a M:M link, which of the following properties must be populated? Choose three.

A. Child business component

B. Inter table

C. Destination field

D. Inter child column

43. When you configure a static drilldown to a different business component, which of the

following you would NOT do? Choose two.

A. Set Hyperlink field and view properties

B. Set business component, source field, and destination field properties to enable

drilldown to a view based on a different parent record

C. Create a new drilldown object for the applet in Siebel Tools

D. Identify one or more matching conditions to trigger drilling down to a specific target

view

E. Set the field, value, and sequence properties

Siebel 7 Consultant Core Exam

Page 72 of 83

44. Which of the following is NOT one of the steps in configuring a dynamic picklist in Siebel

Tools?

A. Set the Type Value property on the picklist to the picklist name in the

S_LST_OF_VAL

B. Specify the Business Component to be used by the Pick List object

C. Set the runtime property to TRUE on the control or list column object

D. Create a Pick Map definition

45. Which of the following are true of Multi-value group (MVG)? Choose two.

A. Its visual cue is

B. It requires dedicated space for each child record on a view

C. Multi-value field is required for an MVG

D. It is an alternative to a detail view for managing parent and related child records

E. It cannot be built on M:M relationships

46. Which of the following is a valid reason to use unused columns of an existing standard 1:1

extension table (rather than creating a custom extension column on the base table)?

A. The columns will very rarely be included in the User Interface, and applies to only

a small subset of the records in the base table

B. It will improve performance

C. It is a solution when you have not purchased the Advanced Database Extensibility

module

D. Siebel does not permit creation of new columns on base tables

Siebel 7 Consultant Core Exam

Page 73 of 83

47. Which of the following access control mechanisms is NOT how Siebel limits records a user

can access in a given view?

A. Membership in access groups for catalogs and categories

B. User ID

C. User’s responsibilities

D. User’s organization

E. User’s position

48. Which of the following is NOT one of the steps of enabling Multilingual List of Values

(MLOVs)?

A. Compile a new .srf and deploy

B. Determine which columns to enable

C. Update the existing data in the database by running the MLOV upgrade utility

D. Configure columns for MLOVs

E. Create 1:M extension table to S_LST_OF_VAL table for each target language

49. For which Contact view do you set the Visibility Applet Type property to Sales Rep?

A. For All Contacts

B. For My Team’s Contacts

C. For My Personal Contacts

D. For All Contacts across Organizations

E. For My Contacts

Siebel 7 Consultant Core Exam

Page 74 of 83

50. Which of the following BusComp View Modes would you set to have My Team's View?

Choose two.

A. Set Visibility Field to Owned By Id

B. Set BusComp Popup Visibility Type to Sales Rep

C. Set Owner Type to Position

D. Set BusComp Visibility MVField to Sales Rep

E. Set View Visibility Applet Type Name to Personal

51. You would like to see Siebel Actuate Reports in Portuguese instead of English. Which of

the following would you use?

A. Regional setting

B. Internationalization

C. Language specific compilation

D. Localization

52. What is the effect of checking out a project? Choose three.

A. Locks the project in the server repository but not in the local repository

B. Locks the projects in the local database repository

C. Locks the projects in the server database repository

D. Copies all object definitions in the project on the server to the local database

Siebel 7 Consultant Core Exam

Page 75 of 83

53. Which of the following populates a newly-initialized local database with a read-only copy of

all projects in the server repository?

A. Database Extract

B. Get

C. Checking Out

D. Checking In

54. To modify the Siebel application what would you do?

A. Modify the application engine that reads the repository file

B. Write custom stored procedures against the repository file

C. Write SQL statements against the repository file

D. Edit object definitions that make up the repository file

55. Which of the following is NOT how you create a Web page in Siebel?

A. Its layout is edited in Siebel Tools

B. Once configured properly, a browser automatically replaces Siebel tags with

Siebel data

C. An applet is associated with a Web template object

D. A web template file is registered in a repository

Siebel 7 Consultant Core Exam

Page 76 of 83

56. How can you limit visibility to a catalog to only those groups associated with the catalog?

A. Adjust the responsibilities associated with the Access Groups to ensure only the

appropriate people have access

B. Set the Visible Flag for the catalog on the Catalog screen

C. Set the Private Flag for the catalog on the Catalog screen

D. Adjust the positions associated with the Access Groups to ensure only the

appropriate people have access

57. Why would you use the ONLY BASE TABLES parameter in your EIM configuration files?

A. To eliminate duplicate data

B. To verify import success

C. To speed up processing

D. To truncate EIM tables after import

58. Which of the following are valid methods for verifying the success of an EIM task? Choose

three.

A. Use the client application to view data

B. Print the contents of the base tables and compare against legacy printouts

C. View Server Manager logs for EIM tasks

D. Use SQL SELECT statements against the EIM and base tables

Siebel 7 Consultant Core Exam

Page 77 of 83

59. You have a Workflow process that evaluates the age of Service Requests and updates the

priority of Service Requests that are more than a week old. Which Siebel Workflow step

type are you using to change the priority of the Service Request?

A. Siebel Update step

B. Siebel Operation step

C. Decision Point step

D. Sub Process step

60. Which Siebel feature enables you to automatically apply a discount to a customer’s order

when the customer adds both a printer and replacement ink cartridges to their online

shopping cart?

A. Siebel Workflow Policy Program

B. Action Sets

C. Siebel Assignment Manager

D. Rule Sets

61. You currently have a Siebel Operation step in a Workflow Process that updates SR priority

from Low to High. You now want the Sub Process step to change the priority to Very High

rather than High. How do you change this detail?

A. Double-click the Siebel Operation step in the Process Designer

B. Delete the step and replace it with a new Sub Process step

C. Right-click the Siebel Operation step in the Process Designer

D. Double-click the Sub Process step in the Process Designer

Siebel 7 Consultant Core Exam

Page 78 of 83

62. Which of the following is an Enterprise Component Group that should be enabled prior to

running Siebel Workflow?

A. Workflow Process Batch Manager

B. Workflow Action Agent

C. Workflow Monitor Agent

D. Workflow Management

E. Workflow Process Manager

63. Which of the following is NOT an option with Siebel Workflow’s Wait Step?

A. Pause a process for a specified amount of time

B. Pause a process until a specified runtime event occurs

C. Include a restart parameter in the process

D. Include a timeout parameter in the process

64. If an applet has five associated Rule Sets, and the first three rule sets will not return any

data for the current user, but the last two rule sets will, how many rule sets are evaluated for

this user?

A. 4

B. 3

C. 2

D. 5

Siebel 7 Consultant Core Exam

Page 79 of 83

65. How can you tell if your connectors in a Siebel Workflow process are successfully

connecting the steps as you create the Workflow process? Choose two.

A. The two ends of the connector will be white in color

B. By running the process using Process Simulator

C. By right-clicking the connector line

D. The two ends of the connector will be red in color

66. Which of the following describes .dx files?

A. Transaction files transferred between the Server and Mobile Client

B. Temporary files that are automatically purged upon application exit

C. Directory files used by Siebel to organize physical file directories

D. Log files used for troubleshooting EIM process errors

67. What is stored in the S_DOCK_TXN_LOG table in the Server Database?

A. Before and after images of data

B. A list of transactions performed while docked

C. All of the data that is changed during a remote session

D. Remote user information

Siebel 7 Consultant Core Exam

Page 80 of 83

68. In the first time set up of mobile users, what must you do before data can be loaded in the

Mobile Client’s local database?

A. Run the dev2prod.ksh script

B. Create the database schema for the local database

C. Copy the Siebel Database file to the mobile client

D. Copy the .cfg and .srf file from the server to the mobile client machine

69. Which server task creates the Docking\User directory on the Siebel Server for a new Mobile

Client?

A. Transaction Router

B. Generate New Database

C. Synchronization Manager

D. Database Extract

70. What does the Transaction Merger server task do when it encounters a Duplicate Conflict?

Choose two.

A. Merges the two records together into one record

B. Adds the duplicate record and sets a flag to indicate that duplicates exist

C. Does not add the duplicate record and logs the conflict in the remote status log

D. Notifies the mobile client of the duplicate

Siebel 7 Consultant Core Exam

Page 81 of 83

71. When does the Transaction Merger server task override the MRG: System Conflict

Resolution system preference?

A. Never

B. When a Duplicate Conflict occurs

C. When an Update Conflict occurs

D. When a Delete Conflict occurs

72. What action is recommended if a mobile user is going to be unable to synchronize for an

extended period of time (leave of absence, for example)?

A. Change the synchronization frequency

B. Modify the views assigned to the mobile client

C. Set a new effective end-date for the mobile client to deactivate it

D. Remove the mobile client’s local database completely

73. When initially preparing your target environment for migration, which of the following tasks

should you complete? Choose three.

A. Check out projects that were changed in development

B. Create user accounts

C. Install any required client software

D. Install database and server software

E. Copy the .srf file to server and clients

Siebel 7 Consultant Core Exam

Page 82 of 83

74. What is dataexp.exe used for when migrating environments?

A. To generate a data merge file that contains user and seed data

B. To create flat files containing data from non-EIM tables

C. To create flat files containing data from EIM tables

D. To generate a compressed copy of the source database

75. Which of the following must you do to reactivate a mobile client? Choose two.

A. Perform a database extract

B. Create the mobile client DOCKING sub-directory on the server

C. Add the server name to the DockConnString line of siebel.cfg

D. Remove the end date for the mobile client

Siebel 7 Consultant Core Exam

Page 83 of 83

Practice Exam Answer Key

1. B 26. D 51. D

2. C 27. CD 52. BCD

3. BCD 28. D 53. B

4. A 29. D 54. D

5. BC 30. C 55. B

6. B 31. D 56. C

7. C 32. C 57. C

8. B 33. A 58. ACD

9. D 34. D 59. B

10. B 35. A 60. B

11. B 36. AB 61. D

12. A 37. C 62. D

13. C 38. E 63. C

14. ACE 39. D 64. A

15. BCD 40. D 65. BD

16. D 41. B 66. A

17. B 42. ABD 67. A

18. D 43. DE 68. B

19. A 44. A 69. D

20. D 45. CD 70. BD

21. D 46. A 71. D

22. D 47. C 72. C

23. A 48. E 73. CDE

24. A 49. E 74. C

25. A 50. CD 75. AD