Tuesday, 8 August 2017

C2150-201 Fundamentals of Applying IBM Security Systems Identity and Access Assurance

Test information:
Number of questions: 64
Time allowed in minutes: 105
Required passing score: 62%
Languages: English, French, Latin American Spanish, Portuguese (Brazil)

Related certifications:
IBM Certified Solution Advisor - Security Systems Identity and Access Assurance

Discovery (21%)
Application: Discover customers needs.
Application: Discover problems the customer is trying to solve.
Application: Analyze the maturity of the customer environment as related to security and IT process.
Application: Assess the current environment and map it to the technical requirements.
Application: Identify and map requirements into product capabilities.
Application: Prioritize the capabilities based on business value drivers and analysis.
Application: List the existing limitations of the customer environment.

Planning (23%)
Application: Prepare a conceptual view of the architecture.
Application: Prioritize and document the technical requirements.
Application: Plan requirements for performance, security, reporting, usability, availability, logging, and regulations. - performance includes product sizing
Comprehension: Identify general requirements for performance, security, reporting, usability, availability, logging, and regulations.
Application: Identify the feasibility requirements in terms of integration.
Application: Define integration points for in scope products with their existing architecture.
Comprehension: Describe product licensing models.
Application: Determine the cost benefit analysis for hardware and software implementation.

Design (26%)
Application: Prepare a Logical view of the architecture.
Application: Create scenarios that address customer's use cases.
Application: Provide suggestions based on product capability.
Application: Streamline and standardize the design based on industry best practices.
Application: Determine data flow model.
Application: Identify the scope and effort involved for customization.
Application: Demonstrate a proof-of-concept to showcase solution capabilities.
Application: Document solution customizations requirements and scope.
Application: Describe business/technical advantages of IBM Security Identity and Access Assurance solutions.
Application: Apply security and compliance concepts to the solution document.
Comprehension: Identify the prerequisites for software installation and configuration.

Develop (17%)
Application: Perform customizations that meet specific needs.
Application: Develop the Physical view from the Logical view.
Comprehension: Describe the basic installation and configuration options.
Application: Describe the basic performance tuning options.
Application: Determine the robustness and scaleability of the solution.

Transition (12%)
Application: Create a go-live plan based on UAT / pre-prod implementation steps including identifying potential pitfalls.

Comprehension: Identify skills a customer needs to have to maintain the solution.

Application: Identify best practices and work around to maintain the solution. - includes backup and restore. These topics are covered in the operational guide.

IBM Certified Solution Advisor - Security Systems Identity and Access Assurance

Job Role Description / Target Audience
An IBM Certified Solution Advisor - IBM Security Identity and Access Assurance is a person who identifies opportunities and influences direction for IBM security solutions within the customer environment and is responsible for educating and influencing key decision makers.

Recommended Prerequisite Skills
Map customer business requirements to IBM Security solutions.
Apply security and compliance concepts and standards to a customer's IT infrastructure.
Assess IT process maturity.
Assess the IT environment for security and compliance gaps.
Align IBM and business partner products and services to security and compliance opportunities.
Assess requirements and create a solution document.
Describe business/technical advantages of IBM Security Identity and Access Assurance solutions.
Apply security and compliance concepts to the solution document.
Recommend education opportunities to customer based on the IBM Security Identity and Access Assurance solutions.
Supply a transition document to interested parties.
Align the security solution with the architectural framework of the customer.
Understand the customer's business needs for identity and access management.
Understand government and industry regulatory compliance needs and requirements.

Requirements
Knowledge of IT security and compliance services (authorization, authentication, confidentiality, data integrity, non-repudiation). - Skill Level 3
Knowledge of IT process model (i.e. Information Technology Infrastructure Library (ITIL)). - Skill Level 2
Knowledge of process maturity models (i.e. Six Sigma). - Skill Level 1
Knowledge of IT security and compliance standards (government and civil), regulations, and certifications (PKI, SSL, SAML, Liberty, etc.). - Skill Level 2
Knowledge of IT professional security and compliance certifications such as CISSP. - Skill Level 1
Knowledge of IT directory/LDAP functionality. - Skill Level 2
Knowledge of IBM Pricing Model - Skill Level 2
Familiarity with key IBM Security Partner products (PKI - VeriSign etc.). - Skill Level 1
Understanding of IBM IBM Security Identity and Access Assurance products -DB2, Directory Integrator, WebSphere, IBM HTTP Server etc.). - Skill Level 2
Conceptual knowledge of networking environments and operating systems.


QUESTION 1
A customer has a requirement which is currently unavailable in an out-of-the-box product.
Who would be able to assist in troubleshooting the customer when developing a custom solution?

A. IBM Sales
B. IBM Support
C. IBM LAB Services
D. Raise an enhancement request with IBM

Answer: C

Explanation:


QUESTION 2
A customer's IT infrastructure includes ten different directories, one for each country branch. The
customer now needs a single directory for some centralized applications. The customer would like
to make as few changes in the environment as possible.
Which product do you recommend?

A. IBM Security Identity Manager
B. IBM Security Directory Server
C. IBM Security Directory Integrator
D. IBM Security Access Manager for Web

Answer: C

Explanation:


QUESTION 3
A company is planning to design an identity and access management solution across multiple data
centers which will automate the user life cycle management and streamline their access
management process.
Which two key design principles should be factored in for designing a comprehensive identity and
access management solution? (Choose two.)

A. Design for integrity
B. Design with single zone
C. Design for accountability
D. Design for single layer of defense
E. Design for single data center and then extend it

Answer: C,D

Explanation:


QUESTION 4
Which scenario is typical for onboarding a new web application into IBM Security Access Manager
for Enterprise Single Sign-On?

A. Use AccessStudio to create a profile in the test environment. Confirm the profile works and use
it directly in the production environment.
B. Create a junction configuration in the test environment, confirm successful authentication,
export configuration from test import into production environment.
C. Use AccessStudio directly in production environment to create a new application profile,
confirm by using the test functionality in AccessStudio, and upload new application profile to
production IMS server.
D. Use AccessStudio to create a new application profile. Add a condition so the profile is only
available to your test users. After confirmation of the test users, remove the condition to enable the
profile for all users in the production environment.

Answer: D

Explanation:


QUESTION 5
A company is using IBM Security Access Manager and wants to extend the functionality of the
help desk users so that they can assist the end user in troubleshooting and diagnostics.
Which WebSEAL functionality is used to allow help desk users to assume the identity of the user
who is a member of the Security Access Manager Domain?

A. Switch User function
B. Switch Admin function
C. Transfer User function
D. Switch Application function

Answer: A

Explanation:




Monday, 24 July 2017

C2090-632 IBM Cognos 10 BI Metadata Model Developer

Test information:
Number of questions: 53
Time allowed in minutes: 60
Required passing score: 71%
Languages: English, French, Japanese

Related certifications:
IBM Certified Advanced Developer - Risk Information Governance for BI
IBM Certified Solution Expert - Cognos BI
IBM Certified Developer - Cognos 10 BI Metadata Models
IBM Certified Solution Expert - Cognos 8 BI Migration

The Cognos 10 BI Metadata Model Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Common Data Structures and Traps (16%)
Identify Common Data Structures
Identify different data traps

Framework Manager Basics (16%)
Identify the different model types that can be published from Framework Manager
Define the purpose of Framework Manager
Create a project
Identify recommendations for preparing metadata

Predictable Results (16%)
Identify recommendations to achieve predictable results
Describe why and how to implement a time dimension
Identify techniques for creating intuitive business views

Security (9%)
Describe the Cognos 10 security environment
Describe how to implement security on models and packages

Project Management and Maintenance (5%)
Identify techniques for managing Framework Manager projects
Identify techniques for managing Framework Manager packages

Query Subject Types (9%)
Identify different query subject types and uses

Generated SQL and Complex Queries (17%)
Identify SQL Generation in Complex Queries
Identify aggregated result sets for multi-fact queries
Identify aggregations in Report Studio SQL

Optimization and Tuning (5%)
Describe the performance impact of queries

Advanced Techniques (7%)
Describe how to leverage user defined functions
Describe how to resolve a recursive relationship
Identify considerations for drill-through values and managing MUNs

QUESTION 1
Which of the following is correct regarding the Cognos 10 security environment?

A. Cognos 10 must be configured to use only one authentication provider at a time.
B. To perform authentication of users, a connection to the Cognos namespace must be defined.
C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
D. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.

Answer: C


QUESTION 2
In Framework Manager, which of the following statements is correct when working with a multi-lingual project?

A. The design language can be changed at any point.
B. A project language cannot be deleted once defined in Framework Manager.
C. A language must be added to the project before it can be published with a package.
D. When a new language is added to a project, all locales for that language are added as well.

Answer: C


QUESTION 3
The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?

A. Query items.
B. Data sources.
C. Relationships.
D. Parameter maps.

Answer: A


QUESTION 4
What must a modeler consider when modeling for drill-through between multiple data sources?

A. Drill-through values must be cast.
B. Drill-through values must be conformed.
C. Drill-through values must be consolidated.
D. Drill-through values must be identifiers.

Answer: B

Saturday, 22 July 2017

C2090-625 IBM Cognos 10 BI Data Warehouse Developer

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

Related certifications:
IBM Certified Developer - Cognos 10 BI Data Warehouses
IBM Certified Advanced Developer - Risk Information Governance for BI
IBM Certified Solution Expert - Cognos BI

The IBM Cognos 10 BI Data Warehouse Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Data Manager and Data Warehousing (4%)
Identify how Data Manager can be used
Distinguish between OLTP systems and data warehouses

Catalogs and Data Source Connections (12%)
Describe the process of creating a catalog
Identify how to use SQLTerm
Describe how to configure text files using SQLTXT Designer
Describe how to package catalog components
Describe how to navigate through catalog components
Describe how to export catalog metadata to Cognos 8

Dimensions and Basic Hierarchies (7%)
Determine appropriate situations for using a hierarchy
Describe the use of the Reference Explorer tool
Describe the use of the Date Hierarchy wizard

Basic Dimension Builds and Fact Builds (12%)
Describe the types of builds
Describe the use of the Dimension Build wizard
Describe the process of creating a fact build
Describe the modification of build settings

Derivations and Derived Dimensions (6%)
Identify the benefits of creating a derivation
Determine the appropriate location to create a derivation
Identify when it would be useful to create a derived dimension

Conformed Dimensions (10%)
Describe the advantages of conformed dimensions
Describe surrogate keys
Describe how to deliver conformed dimensions
Describe how to check data integrity

Hierarchies and Lookups (8%)
Describe ways to modify hierarchies and lookups
Describe how to manipulate data using hierarchies and lookups
Dimensional History and Late Arriving Data (10%)
Describe the use of slowly changing dimensions (SCDs)
Describe the handling of late arriving fact and dimension data

Data Delivery and Data Processing (22%)
Describe delivering fact and dimension data
Describe how to merge and aggregate fact data
Describe how to restrict fact data delivery
Describe how to implement job control
Describe how to pivot fact data

User-Defined Functions (UDFs) and Variables (5%)
Describe how to create UDFs
Describe the use of variables

Troubleshooting and Tuning (4%)
Describe options to address memory and performance issues
Describe how to interpret the log files
QUESTION 1
Where can a developer define variables in Data Manager?

A. Metadata dimensions
B. Connections
C. JobStreams
D. Metadata collections

Answer: C


QUESTION 2
When delivering fact data to a text file, what can be specified?

A. Line and field delimiters
B. Whether the file is in ASCII or EBCDIC format
C. Maximum number of rows to be stored in the file
D. Default text editor to use with the file

Answer: A


QUESTION 3
What can be done to minimize memory consumption?

A. Disable dimension breaking on the fact build.
B. Disable fact build logging.
C. Enable dimension breaking on the fact build.
D. Enable auditing on the fact build.

Answer: C


QUESTION 4
Which of the following is true of the Navigator?

A. When searching for components, wildcards are not supported.
B. When a component is selected, dependent components are shown.
C. Library components (such as hierarchies) cannot be navigated.
D. Components from different catalogs can be compared.

Answer: B

Saturday, 8 July 2017

C2090-612 DB2 10 DBA for z/OS

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically
the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing,
performance, and installation and migration/upgrades specific to the z/OS operating system.

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

The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.

Section 1 - Database Design and Implementation (30%)
Design tables and views
Explain the different performance implications of identity column, row ID, and sequence column definitions (applications, utilities), reorder row format, hash access
Design indexes
Design table spaces (choose a DB2 page size, clustering) and determine space attributes
Perform partitioning
Normalize data (E-R model, process model) and translate data model into physical model (denormalize tables)
Implement user-defined integrity rules
Use the appropriate method to alter DB2 objects
Create and Manage XML and LOB objects
Understand impacts of different encoding schemes
Implementing data distribution and replication

Section 2 - Operation and Recovery (28.5%)
Knowledge of commands for normal operational conditions
Knowledge of commands and utility control statements for use in abnormal conditions
Identify and perform actions that are needed to protect databases from planned and unplanned outages and ensure that timely image copies are taken periodically
Load and unload data into and from the created tables
Reorganize objects when necessary
Monitor the object by collecting statistics
Monitor and manage threads and utilities
Identify and respond to advisory/restrictive statuses on objects
Understanding the significance of checkpoints
Identify and perform problem determination
Perform health checks
Develop backup and recovery scenarios
Describe the special considerations for recovery in a data sharing environment
Understand the concept of disaster recovery
Understanding the concept of virtual storage constraints and limitations

Section 3 - Security and Auditing (9%)
Understanding privileges and authorities
Protect access to DB2 and its objects
Audit DB2 activity and resources and identify primary audit techniques
Identify and respond appropriately to symptoms from trace output or error messages that signify security problems
Create and maintain roles and trusted contexts
Implementing column and row level authorizations

Section 4 - Performance (28.5%)
Plan for performance monitoring by setting up and running monitoring procedures
Analyze performance
Analyze and respond to RUNSTATS statistics analysis
Determine when and how to perform REBIND
Calculate cache requirements for new applications
Understanding and implementing data distribution and replication
Describe DB2 interaction with WLM
Interpret traces and explain the performance impact of different DB2 traces
Identify and respond to critical performance metrics
Review and tune SQL
Dynamic SQL Performance
Design features for performance

Section 5 - Installation and Migration / Upgrade (4%)
Understand the critical ZPARMs
Identify the migration/upgrade modes
Identify & explain Datasharing components

IBM Certified Database Administrator - DB2 10 for z/OS

Job Role Description / Target Audience
The IBM Certified Database Administrator is the lead database administrator (DBA) for the DB2 product on the z/OS operating system. This individual has significant experience as a DBA and extensive knowledge of DB2, specifically the new features and functionality related to version 10. This person is capable of performing the intermediate to advanced tasks related to database design and implementation, operation and recovery, security and auditing, performance, and installation and migration/upgrades specific to the z/OS operating system.

Recommended Prerequisite Skills
Experience as a database administrator on DB2 10 for z/OS DBA and system programming DBA areas
At least two years experience in database administration for the z/OS operating system
Some knowledge and experience in both the application DBA and system programming DBA areas
Knowledge of SQL

Capability to work independently and effectively in complex environments



QUESTION 1
Workload Manager (WLM) manages how many concurrent stored procedures can run in an
address space and the number of concurrent stored procedures in an address space cannot
exceed the value of the NUMTCB parameter. Which statement about the value of NUMTCB is
correct?

A. NUMTCB parameter must be set to 1 for Java stored procedures.
B. NUMTCB parameter must be set to 1 for REXX stored procedures.
C. NUMTCB parameter can be a value greater than 1 for native SQL stored procedures.
D. NUMTCB parameter can be a value greater than 1 when a stored procedure invokes DB2
utilities.

Answer: B

Explanation:


QUESTION 2
If a single row of the PLAN_TABLE has a 'Y' value in more than one of the sort composite
columns, what is indicated?

A. The next sort step will perform two sorts.
B. There are multiple sorts in the plan step.
C. One sort in the plan step will accomplish two tasks.
D. Two sorts are performed on the new table of a star join.

Answer: C

Explanation:


QUESTION 3
What IBM provided stored procedure will access DB2 real time statistics tables?

A. DSNAEXP
B. DSNAIMS
C. DSNACCOX
D. DSNLEUSR

Answer: C

Explanation:


QUESTION 4
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which
information is part of the DSN_STATEMENT_CACHE_TABLE?

A. Filter factor information.
B. Stage 1 and stage 2 information.
C. Number of columns used in an index.
D. Number of times an SQL statement is executed.

Answer: D

Explanation:


QUESTION 5
Which two of the following DB2 performance features will ignore clustering in favor of faster insert
performance? (Choose two.)

A. Append
B. Inline LOBs
C. Member cluster
D. Volatile table
E. Include columns

Answer: A,C

Explanation:

Thursday, 8 June 2017

C9020-560 IBM Midrange Storage Sales V3

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

Gather Customer Requirements (32%)
Identify a customer's storage qualifications.
Identify a customer's expectations of a new solution.
Given a scenario, demonstrate a conceptual level understanding of existing systems environment.
Identify customers key applications, performance requirements, and pain points and information to propose a solution.
Given a scenario, determine financial justification for system acquisition.
Given a scenario, determine a customer's growth requirements, upgrade path, and product lifecycle.

Value Proposition (28%)
Given a scenario, identify how an IBM storage solution aligns with customer requirements.
Given a scenario, quantify the business value of IBM storage products' features and functions and align to business goals.
Compare IBM storage products to customer-installed storage devices and competitive offerings, and identify advantages.
Given a scenario, identify how IBM storage products solve client data management issues.
Identify the value proposition of IBM maintenance, IBM websites, IBM sales tools, and IBM processes.

Determine IBM Solutions / Create Comprehensive Solutions (32%)
Given a scenario, identify the processes and procedures to integrate new solutions into an existing systems environment.
Identify workload characteristics and discuss typical business solutions.
Given a scenario, identify a storage solution that includes multiple products and solves a customer issue.
Identify appropriate resources within IBM or through the business partner channel to develop and close business.
Identify the roles and responsibilities of the business partner or IBM salesperson to use TDA and SAPR to ensure solutions meet the customer's business requirements.

Hybrid Cloud and Analytics Concepts (8%)
Identify ways the IBM storage porfolio enables cloud offerings (hybrid, private, public).
Identify ways the IBM storage porfolio enables analytics.
Identify ways the IBM storage porfolio enables security.

Job Role Description / Target Audience
The IBM Midrange Storage Specialist identifies opportunities for business and generates/qualifies demand using a consultative approach. This specialist determines and effectively uses available tools and resources to determine and sell storage solutions that meet the customer needs and requirements. This specialist has a broad knowledge of the features, functions and benefits of IBM midrange storage solutions and knowledge of competitive solutions. The successful candidate will apply their knowledge of IBM storage products to the customer's environment in an effort to solve business problems.

The IBM storage solutions included in this exam are: hybrid storage, specifically the IBM Storwize Family (IBM Storwize V5000; IBM Storwize V7000 and V7000 Unified); IBM FlashSystem Family; midrange tape (LTO); IBM Spectrum Protect; IBM Spectrum Virtualize; SDS concepts; and VersaStack (IBM components). A basic understanding and general knowledge of IBM Storwize V3700; DCS3700; IBM Storage Cloud; IBM Spectrum Control; V7000 Gen1 Storwize V5000; and SVC are also recommended.

This specialist can perform the following tasks without assistance: determine basic product positioning across the full IBM storage product portfolio; gather customer requirements; identify and engage correct resources, including technical support, customer demonstration facilities and tools; possess general knowledge of the competitive landscape for midrange storage products; understand TCO/ROI fundamentals; articulate features/benefits/fit of IBM midrange storage products to solve customer problems; identify warranty, installation and support options; deal registration; know where to locate training materials and sales support materials (e.g., sales kits); and articulate CAMSS basics.

This specialist can perform the following tasks with assistance: drill down into solution specifics; articulate and present the configuration to the customer; mitigate competitors; develop the solution; be aware of the purpose and general capabilities of Disk Magic and Capacity Magic; be aware of the Solutions Assurance/TDA process, and where to find specific information on TDA requirements for midrange products; and articulate IBM midrange storage solutions relative to private and hybrid cloud implementations.

This specialist should be familiar with the following resources: eConfig; ePricer; competitive sales tools such as COMP database and CompeteCenter; Briefing Centers; TCONow!; IBM Systems Consolidation Evaluation Tool hosted by Alinean; IBM PartnerWorld; Migration Factory; Storage Assessments (in the Storage Playbook); Storage Playbook; and Visual Storage Intelligence.

Recommended Prerequisite Skills
Minimum 12 months practical experience selling midrange storage solutions with six months experience selling IBM midrange solutions.

QUESTION 1
The sales specialist is recommending an IBM TS7620 to achieve greater efficiency with a client's current environment.
What is a potential benefit to the client?

A. Faster performance of their primary applications
B. Simplify legal and regulatory compliance
C. Minimize risk by sending tapes offsite
D. Higher productivity due to shorter backup windows

Answer: A


QUESTION 2
A medium-sized SMB customer with an HP EVA 6350 needs new features that the HP system cannot provide.
The general business customer asks for a solution with easy migration and the ability to virtualize the old storage.
Which cost-sensitive IBM system should seller recommend?

A. IBM Storwize V3700 with external virtualization licenses
B. IBM Storwize V3700 with full featurebundle
C. IBM Storwize V5010 with full feature bundle
D. IBM Storwize V5030 with external virtualization licenses

Answer: B


QUESTION 3
A customer has a requirement for a low cost tape library. The library must support reparation of library resources (tape drives and cartridge slots) for four different application servers.
Which tape library should the sales specialist recommend?
A. IBM TS3200
B. IBM TS4500
C. IBM TS3500
D. IBM TS3100

Answer: D


QUESTION 4
A customer has a cluster of file servers running IBM Spectrum Protect as the backup application. The client wants to reduce backup and recovery time while eliminating physical tape handling.
Which IBM storage solution meets the requirement to work like a tape library and is based on disk storage?

A. IBM TS7620 with Deduplication
B. IBM Storwize V7000 with Easy Tier
C. IBM TS3500 with LTO-6 drives
D. IBM FlashSystem V9000 with thin provisioning

Answer: A


QUESTION 5
Which resource should an IBM Business Partner representative consult for current IBM storage sales programs and incentives?

A. IBM Client Technical Specialist
B. IBM Business Partner Sales Playbooks on PartnerWorld
C. IBM Business Partner Client Executive
D. IBM Digital Technical Center

Answer: B

Friday, 19 May 2017

C2090-102 IBM Big Data Architect

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

This test consists of 5 sections containing a total of 55 multiple-choice questions. The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Requirements (16%)
Define the input data structure
Define the outputs
Define the security requirements
Define the requirements for replacing and/or merging with existing business solutions
Define the solution to meet the customer's SLA
Define the network requirements based on the customer's requirements

Use Cases (46%)
Determine when a cloud based solution is more appropriate vs. in-house (and migration plans from one to the other)
Demonstrate why Cloudant would be an applicable technology for a particular use case
Demonstrate why SQL or NoSQL would be an applicable technology for a particular use case
Demonstrate why Open Data Platform would be an applicable technology for a particular use case
Demonstrate why BigInsights would be an applicable technology for a particular use case
Demonstrate why BigSQL would be an applicable technology for a particular use case
Demonstrate why Hadoop would be an applicable technology for a particular use case
Demonstrate why BigR and SPSS would be an applicable technology for a particular use case
Demonstrate why BigSheets would be an applicable technology for a particular use case
Demonstrate why Streams would be an applicable technology for a particular use case
Demonstrate why Netezza would be an applicable technology for a particular use case
Demonstrate why DB2 BLU would be an applicable technology for a particular use case
Demonstrate why GPFS/HPFS would be an applicable technology for a particular use case
Demonstrate why Spark would be an applicable technology for a particular use case
Demonstrate why YARN would be an applicable technology for a particular use case

Applying Technologies (16%)
Define the necessary technology to ensure horizontal and vertical scalability
Determine data storage requirements based on data volumes
Design a data model and data flow model that will meet the business requirements
Define the appropriate Big Data technology for a given customer requirement (e.g. Hive/HBase or Cloudant)
Define appropriate storage format and compression for given customer requirement

Recoverability (11%)
Define the potential need for high availability
Define the potential disaster recovery requirements
Define the technical requirements for data retention
Define the technical requirements for data replication
Define the technical requirements for preventing data loss

Infrastructure (11%)
Define the hardware and software infrastructure requirements
Design the integration of the required hardware and software components
Design the connectors / interfaces / API's between the Big Data solution and the existing systems

Job Role Description / Target Audience
The Big Data Architect works closely with the customer and the solutions architect to translate the customer's business requirements into a Big Data solution. The Big Data Architect has deep knowledge of the relevant technologies, understands the relationship between those technologies, and how they can be integrated and combined to effectively solve any given big data business problem. This individual has the ability to design large-scale data processing systems for the enterprise and provide input on the architectural decisions including hardware and software. The Big Data Architect also understands the complexity of data and can design systems and models to handle different data variety including (structured, semi-structured, unstructured), volume, velocity (including stream processing), and veracity. The Big Data Architect is also able to effectively address information governance and security challenges associated with the system.

Recommended Prerequisite Skills
Understand the data layer and particular areas of potential challenge/risk in the data layer
Ability to translate functional requirements into technical specifications.
Ability to take overall solution/logical architecture and provide physical architecture.
Understand Cluster Management
Understand Network Requirements
Understand Important interfaces
Understand Data Modeling
Ability to identify/support non-functional requirements for the solution
Understand Latency
Understand Scalability
Understand High Availability
Understand Data Replication and Synchronization
Understand Disaster Recovery
Understand Overall performance (Query Performance, Workload Management, Database Tuning)
Propose recommended and/or best practices regarding the movement, manipulation, and storage of data in a big data solution (including, but not limited to:
Understand Data ingestion technical options
Understand Data storage options and ramifications (for example , understand the additional requirements and challenges introduced by data in the cloud)
Understand Data querying techniques & availability to support analytics
Understand Data lineage and data governance
Understand Data variety (social, machine data) and data volume
Understand/Implement and provide guidance around data security to support implementation, including but not limited to:
Understand LDAP Security
Understand User Roles/Security
Understand Data Monitoring
Understand Personally Identifiable Information (PII) Data Security considerations

Software areas of central focus:
BigInsights
BigSQL
Hadoop
Cloudant (NoSQL)

Software areas of peripheral focus:
Information Server
Integration with BigInsights, Balanced Optimization for Hadoop, JAQL Push down capability, etc
Data Governance
Security features of BigInsights
Information Server (MetaData Workbench for Lineage)
Optim Integration with BigInsights (archival)
DataClick for BigInsights (Future: DataClick for Cloudant - to pull operation data into Hadoop for Analytics - scripts available today)
BigMatch (trying to get to a single view)
Guardium (monitoring)
Analytic Tools (SPSS)
BigSheets
Support in Hadoop/BigInsights
Data Availability and Querying Support
Streams
Interface/Integration with BigInsights
Streaming Data Concepts
In memory analytics
Netezza
DB2 BLU
Graph Databases
Machine Learning (System ML)


QUESTION 1
What are the two levels documented in the Operational Model? (Choose two.)

A. Logical
B. Rational
C. Theoretical
D. Physical
E. Middleware

Answer: A,C


QUESTION 2
The inputs to the Architectural Overview document do NOT include which of the following?

A. Architectural Goals
B. Key Concepts
C. Architectural Overview Diagram
D. Component Model

Answer: D


QUESTION 3
The downside of cloud computing, relative to SLAs, is the difficulty in determining which of the following?

A. Root cause for service interruptions
B. Turn-Around-Time (TAT)
C. Mean Time To Recover (MTTR)
D. First Call Resolution (FCR)

Answer: A

Explanation:
References: https://en.wikipedia.org/wiki/Service-level_agreement


QUESTION 4
“The programming model for client developers will hide the complexity of interfacing to legacy systems” is an example of which of the following?

A. A use case
B. An architectural decision
C. A client imperative
D. An empathy statement

Answer: B


QUESTION 5
Which of the following is the artifact that assists in ensuring that the project is on the right path toward success?

A. Component Model
B. Empathy Map
C. Viability Assessment
D. Opportunity Plan

Answer: C

Saturday, 13 May 2017

Exam 70-348 Managing Projects and Portfolios with Microsoft PPM

Published: July 28, 2016
Languages: English
Audiences: IT professionals
Technology: Office 365 Project Portfolio Management
Credit toward certification: MCP

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Create projects and programs
Define strategy
Define business drivers, create multiple driver prioritizations, analyze consistency ratio
Optimize portfolios
Capture project requests and ideas, rate projects against business drivers, determine primary cost constraints, determine resource constraints, set project dependencies, create a portfolio analysis, review and modify prioritizations in an analysis, force projects in and out of analysis, determine hired resources, compare and run simulations for project portfolio selection, add additional constraints
Create a new enterprise project
Create a project and manage workflow, use workflow approvals, import projects through Project Professional, create and manage project schedules using Project Web App, save and check in projects, import projects from Excel
Create programs
Insert sub-projects, create cross-project task dependencies, calculate sub-project summary fields, associate programs to portfolios, associate projects to programs

Plan projects and programs
Define deliverables
Add deliverables, set dependencies on deliverables, synchronize deliverables with project, link related items
Create tasks and a Work Breakdown Structure (WBS)
Create and modify summary tasks and subtasks, rearrange tasks, create milestones, create manually scheduled tasks, set tasks as active or inactive
Schedule the project
Set date constraints, deadlines, dependencies, links, duration equations, effort-driven tasks, and formulas; choose task types; enter duration; set or change the task mode (manual or auto); display warnings and suggestions; use estimated durations and user-controlled summary tasks
Manage resources and teams
Edit resources with Project Web App, edit resources with Project Pro for Office 365, create team resources, create team assignments, add a team task to a task page or timesheet, map resource roles (Portfolio analysis)
Perform resource engagement
Submit, accept, modify, and reject a resource engagement request; build a team for a resource plan; build a resource plan for a project; set resource utilization; use committed versus proposed assignments
Build a project team
Build a Project Team through Project Pro for Office 365 or Project Web App, build a Project Team through Project Web App, replace generic resources, work with proposed assignments
Resolve resource over allocations across projects
Level resources using leveling methods; plan resource allocations using Team Planner, Task usage, Resource Requests page, and Resource Utilization
Build a financial plan
Plan program financial requirements using the resource rate table, cost per use, cost resources

Track projects and programs
Baseline enterprise projects
Set a protected baseline, set a baseline from Project Web App and Project Pro for Office 365, clear and copy a baseline
Select tracking method
Use percent complete, hours per period, actual work remaining, freeform, done, and not done fields
Manage task assignments
Publish assignments, select a status manager, select an assignment owner, set the published values for individual tasks
Update tasks and timesheets
Submit and recall timesheets, insert and remove tasks, reassign tasks, submit updates from My Tasks, submit updates from a mobile app
Approve tasks and timesheets
Accept task updates from tasks or timesheets, view impact of updates on a project, reject updates, approve and reject timesheets, manage delegations
Update the project plan
Reschedule uncompleted work, update cost resources, publish schedule changes, utilize task update history, update schedules with protected user updates, close tasks for updates
Collaborate and communicate projects and programs
Create a project site; add Document Library; add Lists, Calendar, and Folders; modify site layout; create program (master-sub) structure using subsites; add risks and issues

Control, report, manage, and extend the PPM solution

Customize Project Web App views and reports
Create a portfolio report using Excel; create dashboards; copy and edit views; set default views; rename field names; group, filter, and sort views
Advanced Reporting
Load the content pack with Power BI, create reports and dashboards, ask natural language questions, leverage filters, pin results to the dashboard, create views with tiles from multiple datasets and reports, create reports using the out-of-the-box reporting capability
Manage configurable enterprise objects
Create and manage enterprise project templates, define enterprise custom fields, define Project workflows, define enterprise global objects, extend with Office Store apps, add social elements
Implement a security model
Change between SharePoint Security mode and Project Security mode, create users, create and modify security groups and categories, set up Project Site permissions
QUESTION 1
Your company has had several large projects fail due to cost overruns and the lack of available resources. These projects use an enterprise project type named Large IT Project and use a workflow to govern the approval of the projects. The workflow consists of four phases; Initiate, Plan, Execute, and Close.
You need to use Microsoft PPM to compare the value that a new project provides with the cost of implementing the project.
Which three configuration changes should you make? Each correct answer presents part of the solution.

A. Navigate to PWA Settings Edit the Large IT Project project type, and in the Available Project Detail Page section, add the Strategic Impact form.
B. Create a project-level custom field that will be used to enter the total cost of a project
C. Define your company's strategic drivers, and enter them into the Strategic Impact form.
D. Create a project-level custom field that will be used to enter the value statements of why this project should be undertaken.
E. Define your company's strategic drivers and enter them into the driver library.
F. In PWA Settings, edit and then save the stage information. In the Available Project Detail Page section, add the Strategic Impact.

Answer: B,C,E


QUESTION 2
You are using Microsoft PPM to manage an e-commerce portal development program. The program is separated into individual projects that represent each area of development.
You have the following requirements:
• All work and progress on individual projects must be reflected in the e-commerce portal development program.
• Each group must be able to manage their own tasks.
You need to set up the e-commerce portal development program and its associated projects in Microsoft PPM.
Where should you add resources?

A. in the e-commerce portal development program project site
B. in the individual project schedules
C. in Build Team, in the e-commerce portal development program schedule
D. in the individual project sites

Answer: C