PK0-004 CompTIA Project+

Maximum of 95 questions

Multiple choice questions (single and multiple response), and drag and drops

90 Minutes

At least 12 months of cumulative project management experience or equivalent education

CompTIA Project+ certifies the knowledge and skills of professionals in project management. Project+ validates the ability to initiate, manage and support a project or business initiative. And it’s not just for IT technicians; Project+ is designed for any individual who wants to validate project management experience.

Overview
Project management skills are needed in almost every field and can separate you from the rest of the workforce. CompTIA Project+ validates project management skills to employers, both inside and outside the IT profession. Even the smallest projects can benefit from project management processes.

Well-run projects save time and ensure continued focus on company goals. The CompTIA Project+ certification validates the communication and business skills you need to lead projects with confidence, complete projects on time and make sure you stay within budget. Learn more from this infographic.

Project+ answers essential business requirements
Companies increasingly require employees to understand project management skills. 15.7 million new project management roles will be added globally across seven project-intensive industries by 2020.1

Project+ opens new career opportunities
Project Management is fourth in specialized skills in IT job postings. It is also the third hottest in demand tech skill with 39% of respondents with hiring plans said they will be seeking people with this skill in the next 12 months.2

CompTIA Project+ is designed for business professionals who coordinate or manage small-to-medium-size projects, inside and outside of IT. The exam certifies the knowledge and skills required to manage the project life cycle, ensure appropriate, communication, manage resources, manage stakeholders, and maintain project documentation.

Training Materials
There’s a wealth of training materials available that match your learning needs and learning style. Whether you are studying on your own, or in a classroom environment, we recommend CompTIA Authorized Quality Curriculum (CAQC) training materials that will help you get ready for your certification exam and pass the test.
QUESTION 1
Which of the following events would MOST likely trigger communications to the largest audience for a given organization?

A. Business continuity response
B. Quality audit
C. Replacement of a subcontractor
D. Completion of a task

Answer: A

---

QUESTION 2
A team lead informs the project manager that the datacenter will not be accessible when the project needs to be completed
The team lead also indicates that the team member who is assigned to complete the datacenter project is out on medical leave
Which of the following should a project manager update to document this information?

A. A list of realized risks
B. A list of decomposed activities
C. A sequenced list of project tasks
D. A document describing agreed-upon communication methods

Answer: A

---

QUESTION 3
Which of the following is a characteristic of a matrix organization?

A. Authority lies solely with the project manager.
B. Authority is directed by the project architect.
C. Authority is shared between the project manager and project coordinator.
D. Authority is shared between functional and project managers.

Answer: D

---

QUESTION 4
When a risk event occurs, which of the following documents is BEST suited for recording and tracking new items corresponding to the risk?

A. Issue log
B. Risk management plan
C. Communications plan
D. Risk register
E. Status report

Answer: C

Click here to view complete Q&A of PK0-004 exam
Certkingdom Review

Best CompTIA PK0-004 Certification, CompTIA PK0-004 Training at certkingdom.com

C2090-560 PureData System for Analytics v7.1

Test information:
Number of questions: 67
Time allowed in minutes: 90
Required passing score: 63%
Languages: English, Japanese

Section 1 Database Design
Ability to design, create and manage databases and database objects (tables, views, etc.)
Ability to create and manage users and groups
Knowledge of the Netezza schema concept
Demonstrate the ability to design, implement and maintain materialilzed views
Knowledge of the benefits of clustered based tables
Demonstrate knowledge and application of sequences
Demonstrate knowledge of zone maps
Demonstrate knowledge of and application of data types
Demonstrate knowledge of table defaults and constraints

Section 2 Physical Optimization
Demonstrate knowledge of data distribution and skew
Ability to select an appropriate data distribution key
Knowledge of PureData System for Analytics implementation of temporary tables
Demonstrate knowledge of optimizer settings
Abilty to maintain statistics and knowledge of impact on performance
Demonstrate the abillity to correctly size system for capacity planning
Abilty to utlize groom table feature and knowledge of impact on performance and storage

Section 3 Netezza Appliance Components
Knowledge of the TwinFin architecture and disks/dataslices
Ability to identify the number of disks/dataslices on a system
Knowledge of the appliance architecture (FPGA, SPU, Disk Array, etc.)

Section 4 High Availability Architecture
Demonstrate knowledge of Linux High Availability (HA) and Distributed Replicated Block Device (DRDB)
Knowledge of behavior of nzLoad and query processing with a state change (host, disk, blade)

Section 5 Security
Knowledge of access/priviledge database objects
Knowledge of using Lightweight Directory Access Protocol (LDAP)�
Knowledge of Linux system administration�
Knowledge of ODBC/JDBC in a Unix or Windows environment and OLE-DE connectivity
Knowledge of new cryptographics mode and Row Secure Tables

Section 6 Data Movement
Demonstrate ability to use external tables in loading and unloading data
Demonstrate ability to use backup/restore utilities
Demonstrate ability to perform inserts (external tables vs cross system)
Demonstrate ability to design cross database access
Demonstrate ability to use nzload

Section 7 Monitoring and Performance
Demonstrate knowledge of log files
Demonstrate knowledge of locks with update, delete, insert, and select
Demonstrate knowledge of transactions that use temporary tables
Demonstrate knowledge of system views
Describe alerts
Describe data flow and life of a query
Demonstrate knowledge of compression
Demonstrate knowledge of broadcasts and co-location/redistribute
Demonstrate knowledge of data skew
Analyzing Query Plan Files (Explain plans vs execution plans; Joins (expression based, cross product, merge, hash joins); recognizing the correct query plan (original vs executing))
Performance Tuning (Multiple Snippets (Data Restrict Optimization); Snippets Limiter; Invisible Columns)

Section 8 Troubleshooting
Demonstrate knowledge of directory location (log files)
Demonstrate knowledge of nzdumpschema
Demonstrate knowledge of Event Manager Changes

Section 9 Operations
Ability to manage the system using the command line interface
Demonstrate knowledge of NZ_ defaults settings

Query History (Enablement, management, selection tables, configuration files, staging, notifications)
Software Support Toolkit (common tasks - migration, table movement)
Backup and Recovery
Replication
System Health Check (basic and advanced)
Demonstrate knowledge to administer BI and Analytic functionality

Section 10 Transaction Management
Serialization issues
Data Columns (housekeeping) (CreateXID, DeleteXID, RowID)
Unreferencable rows

Section 11 Workload Management
GRA (Guarenteed Resource Allocation)
PQE (Priority Query Execution)
SQB (Short Query Bias)
Virtual Tables
New features (7.1 and later)�
Scheduler Rules

IBM Certified Specialist - PureData System for Analytics v7.1

Job Role Description / Target Audience
An IBM Certified Specialist drives the design, implementation and support applications on the PureData System for Analytics platform. This individual has experience designing a PureData System for Analytics in accordance with best practices of ETL, BI, data modeling, and analytical solution.

Recommended Prerequisite Skills
Knowledge and experience managing IBM PureData System for Analytics Platform applications
Knowledge of SQL fundamentals within IBM PureData System for Analytics Platform applications
Experience in data warehouse industry best practices
Basic understanding of Linux and UNIX

---

QUESTION 1
What are the minimum permissions required to install an IBM Tivoli Endpoint Manager (TEM) Relay from the TEM Console?

A. TEM Operator
B. Local Administrator
C. Domain Administrator
D. TEM Master Operator

Answer: A

---

QUESTION 2
What is an IBM Tivoli Endpoint Manager analysis?

A. It allows viewing of various client properties.
B. It allows changing of various client properties.
C. It is a task used to analyze the status of the clients.
D. It is a Fixlet used to analyze the status of the clients.

Answer: A

---

QUESTION 3
What statement is correct when assigning roles to Active Directory security groups in IBM Tivoli Endpoint Manager Web Reports?

A. Security groups can be assigned any role.
B. Security groups can only be assigned the role Normal.
C. Security groups can only be assigned the role Read-only.
D. Security groups can only be assigned the role Administrator.

Answer: A

---

QUESTION 4
Which statement is true about Relay Affiliation group names?

A. The names are case sensitive.
B. Names must start with a double underscore.
C. Names must not use a relay machine name.
D. Any naming scheme can be set up by an administrator.

Answer: D

---

QUESTION 5
Why would an IBM Tivoli Endpoint Manager (TEM) administrator use the task relay setting Name Override?

A. to provide an alternate domain name for the agent connections to a relay
B. to have the relay report a different name to the server to avoid name collision with another relay
C. to have the relay display a different name in the TEM Console than its default name so it can be grouped with other relays
D. to have the relay use a different domain name so it can be part of a Managed Service Point segmented customer environment

Answer: A

Click here to view complete Q&A of C2090-560 exam
Certkingdom Review

Best IBM C2090-560 Certification, IBM C2090-560 Training at certkingdom.com

C2090-543 DB2 9.7 Application Development

Test information:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 60%
Languages: English

This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to design, build, execute, and deploy DB2 9.7 database applications.

Significant experience with intermediate or advanced level skills in developing applications that interact with DB2 databases. This individual has strong skills in DB2 SQL and in database application development concepts.

Section 1 - Database Objects (11%)
Demonstrate knowledge of naming conventions of DB2objects
Aliases
Views
Tables
Describe when to use SQL routines, functions and modules
How to use DB2's built-in routines
Functions
Stored procedures
Demonstrate knowledge of data types
Integer
Floating point
Strings
Date/time
LOBs
XML data type

Section 2 - Traditional Data Manipulation (32%)
Demonstrate knowledge of authorities needed to access datain an application
Describe the differences between dynamic and static SQL
Demonstrate knowledge of how to query databases acrossmultiple tables and views
Given a scenario, demonstrate knowledge of changing data
Insert
Update
Delete
Demonstrate knowledge of cursors
Types of cursors
Read only
Updatable
Scrollable
Scope of cursors
Create and manipulate cursors
Given a scenario, demonstrate the ability to manipulate largeobjects
Locators
Demonstrate the ability to manage a unit of work
Isolation levels
COMMIT
ROLLBACK
SAVEPOINT

Section 3 - XML Data Manipulation (15%)
Given a scenario, demonstrate knowledge of XML schemavalidation
XML schema evolution
Demonstrate the ability to use XML functions
XMLPARSE
Whitespace handling
XMLSERIALIZE
XMLTRANSFORM
Functions for preparing XML documents fromrelational data
Given a scenario, demonstrate knowledge of how to useXQuery expressions and evaluate the results
Given a scenario, describe how to construct queries thatretrieve both traditional and XML data

Section 4 - Core Concepts (27%)
Describe how to bind and rebind a package
Given a scenario, demonstrate knowledge of using parametermarkers
Demonstrate knowledge of how to connect to a database (mayuse scenarios)
JDBC
ADO.NET
CLI/ODBC
php_ibm_db2
Embedded SQL
Demonstrate the ability to submit an SQL statement
JDBC
ADO.NET
CLI/ODBC
php_ibm_db2
Embedded SQL
Describe how to manipulate result sets
JDBC
ADO.NET
CLI/ODBC
php_ibm_db2
Embedded SQL
Demonstrate knowledge of problem determination
JDBC
ADO.NET
CLI/ODBC
php_ibm_db2
Embedded SQL

Section 5 - Advanced Programming (15%)
Given a scenario, describe how to create and register externalstored procedures
Given a scenario, describe how to create external functions
OLE DB table
External table
Given a scenario, demonstrate knowledge of how changingdata will work when referential constraints are involved
Demonstrate knowledge of distributed unit of work (two phasecommit)
Demonstrate knowledge of trusted contexts
Demonstrate knowledge of using advanced database objects
Global declared temporary tables
Sequences
MQTs

IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows

Job Role Description / Target Audience
This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to design, build, execute, and deploy DB2 9.7 database applications.

Recommended Prerequisite Skills
Significant experience with intermediate or advanced level skills in developing applications that interact with DB2 databases. This individual has strong skills in DB2 SQL and in database application development concepts.

Requirements

This certification requires 2 test(s).
Test(s) required:

Any 1 of the following tests:
Test C2090-700 - DB2 V8.1 Family Fundamentals
Test C2090-730 - DB2 9 Family Fundamentals
Test C2090-610 - DB2 10.1 Fundamentals
Test C2090-543 - DB2 9.7 Application Development

---

QUESTION 1
Which condition will prevent a developer from using the DB2 Call Level Interface in an application?

A. The developer must control the cursor names to comply with company naming standards.
B. An SQL precompiler is not available to the developer.
C. The application must create an external scalar function with the CREATE FUNCTION
statement.
D. The DECLARE CURSOR statement needs to be used.

Answer: D

Explanation:

---

QUESTION 2
The statement below was used to create a cursor named CSR1:
DECLARE csr1 DYNAMIC SCROLL CURSOR FOR
SELECT * FROM employee;
After fetching all of the rows in the result set associated with cursor CSR1, which two statements
can be used to fetch the data starting at the end of the result set? (Choose two.)

A. FETCH LAST
B. FETCH PRIOR
C. FETCH RELATIVE
D. FETCH OFFSET

Answer: B,C

Explanation:

---

QUESTION 3
Click the Exhibit button.
CREATE TABLE store(sid INTEGER, info XML);
INSERT INTO store VALUES (1,
'<storeinfo sid="1">
<name>Grocery A</name>
<items>
<fruit><name>Mango</name><price>1.20</price></fruit>
<fruit><name>Apple</name><price>0.50</price></fruit>
<dessert><name>Ice Cream</name><price>6.00</price></dessert>
</items>
</storeinfo>');
Given the statements shown in the exhibit, a user executes the query shown below:
XQUERY for $store in db2-fn:xmlcolumn('STORE.INFO')/storeinfolet $items := $store/items/fruit,
$count := fn:count($items) return <itemcount>$count</itemcount>
What is the output?

A. 2
B. <itemcount>2</itemcount>
C. <itemcount>1</itemcount>
D. <itemcount>$count</itemcount>

Answer: D

Explanation:

---

QUESTION 4
You have created a stored procedure (MULTIRESULTS()) on the server which will return multiple
result sets. Whiledeveloping a PHP application using the IBM_DB2 extension, you want to call the
stored procedure. The code shown below will execute the stored procedure:
$stmt = db2_exec($conn, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?

A. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result
sets.
B. Call db2_next_result($stmt) for each result set.
C. Call db2_fetch_object($stmt) for each result set.
D. Call db2_next_result($stmt) for each result set; call db2_fetch_object($stmt) for each row in the
result set.

Answer: A

Explanation:

Click here to view complete Q&A of C2090-543  exam
Certkingdom Review

Best IBM C2090-543 Certification, IBM C2090-543 Training at certkingdom.com

Exam 1Z0-347 Oracle Order Management Cloud 2017 Implementation Essentials

Exam Details
Duration: 105
Number of Questions:  60
Passing Score: 60%
View passing score policy
Validated Against:  This exam has been validated against Oracle Order Management Cloud Solutions R11.
Format: Multiple Choice

Exam Preparation

Oracle Order to Cash Cloud Overview
Describe different Order types (e.g. Standard order, Return order)
Describe Fulfillment Lines and Orchestration Plans
Create Extensible Flexfields and explain User Interface customization for Cloud

Manage Order Pricing
Describe a Pricing Strategy
Describe Price Lists
Describe Discount Lists
Describe Shipping Charge Lists
Create Pricing Rules and a Price Matrix

Global Order Promising
Create Order Promising Rules (Sourcing and Allocation rules)
Describe Data Collection and Order Promising
Describe Resolution of Backlog and Rescheduling of orders

Order Transformation

Explain types of Transformation
Create Business Rules for Transformation
Describe Source Systems
Describe Web Services
Create Defaulting Rules

Order Orchestration
Define Orchestration
Identify Components of Orchestration and create an Orchestration process
Describe Orchestration statuses
Define and Manage Jeopardy
Manage Fulfillment Systems
Manage Fulfillment Lines

Change Management and Process Assignment
Explain Change Management
Manage Compensation
Define Process Assignment Rules
Revise Orders (add, modify, or cancel)

Processing Constraints and Hold Codes
Create a Constraint Entity and a Processing Constraint (including Order Validation)
Describe the creation of a Hold Code
Release a Hold and Processing Constraint

Managing External Interfaces
Describe Web Services Registration
Create External Interface Routing Rules
Explain Notifications of Business Events
Set up a Fulfillment Order Task Layer
Import Orders

Configure Orders
Select Configurable options in a Configurable product
Integrate with Oracle Pricing

Shipping
Describe the set up for basic Shipping
Manage Pick Waves and Pick Confirm transactions
Describe Ship Confirm
Create Shipping Rules

Advance Fulfillment and Integrations
Explain Advance Order processing (Back to Back, ISO, DropShip)
Create an Internal Sales Order utilizing the integration with Procurement Cloud
Describe the creation of Back to Back and DropShip orders utilizing the integration with Procurement Cloud
Explain the Integration with Manufacturing and Planning Cloud

Reporting and Analytics for Order Management
Set up BI and Reporting
Set up Oracle Transactional Business Intelligence (OTBI) Metrics
Describe customized Reporting

Within 30 minutes of completing your Oracle Certification exam, you will receive an email from Oracle notifying you that your exam results are available in CertView. If you have previously authenticated your CertView account, simply login and select the option to "See My New Exam Result Now."

If you have not authenticated your CertView account yet at this point, you will need to proceed with your account authentication.

Authentication requires an Oracle Single Sign On username and password and the following information from your Pearson VUE profile: email address and Oracle Testing ID. You will be taken to CertView to log in once your account has been authenticated.

---

QUESTION 1
In a Cloud Order Management implementation, a customer has order capture and fulfillment systems located across the globe.
The customer would like to ensure that the time zone is reflected in each transaction based on the location of the entity.
What step is required in order to achieve this business requirement?

A. Select the time zone when importing atransaction to the Order Management System.
B. Select the time zone in user preferences when entering a transaction.
C. Select the time zone by using the prole option in the Functional Setup Manager,
D. Select the time zone during the configuration of theSource system.

Answer: C

Explanation:
Referencehttps://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T575363.htm

---

QUESTION 2
Which action must be performed on the orchestration process user interface to
activate an orchestration process after the order orchestration configurations are completed?

A. Download the generated orchestration process.
B. Validate the orchestration process.
C. Release the orchestration process.
D. Release and deploy the orchestration process.

Answer: B

---

QUESTION 3
Your company has a single global installation that contains Oracle Cloud Product Management,
Oracle Cloud Trading Community Model, and Cloud Order Management.
It has all the execution systems implemented in tandem with Global Order Promising.
The Master data elements have also been migrated to their respective areas. The next step is
to run the date collection program to load the planning data repository.
Which five data elements will the collection program load into the planning data repository? (Choose five.)

A. Currencies
B. Shipping methods
C. Suppliers
D. Customers
E. Items
F. Cross-referenced data
G. Calendars

Answer: C,D,E,F,G

Explanation:
Referencehttps://docs.oracle.com/cloud/latest/scmcs_gs/FASCP/FASCP2173675.htm#FASCP2173675

Click here to view complete Q&A of 1Z0-347 exam
Certkingdom Review

Best Oracle 1Z0-347 Certification, Oracle 1Z0-347 Training at certkingdom.com