Thursday, May 18, 2017

C2090-101 IBM Big Data Engineer

Test information:
Number of questions: 53
Time allowed in minutes: 75
Required passing score: 65%
Languages: English

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

Data Loading (34%)
Load unstructured data into InfoSphere BigInsights
Import streaming data into Hadoop using InfoSphere Streams
Create a BigSheets workbook
Import data into Hadoop and create Big SQL table definitions
Import data to HBase
Import data to Hive
Use Data Click to load from relational sources into InfoSphere BigInsights with a self-service process
Extract data from a relational source using Sqoop
Load log data into Hadoop using Flume
Insert data via IBM General Parallel File System (GPFS) Posix file system API
Load data with Hadoop command line utility

Data Security (8%)
Keep data secure within PCI standards
Uses masking (e.g. Optim, Big SQL), and redaction to protect sensitive data

Architecture and Integration (17%)
Implement MapReduce
Evaluate use cases for selecting Hive, Big SQL, or HBase
Create and/or query a Solr index
Evaluate use cases for selecting potential file formats (e.g. JSON, CSV, Parquet, Sequence, etc�)
Utilize Apache Hue for search visualization

Performance and Scalability (15%)
Use Resilient Distributed Dataset (RDD) to improve MapReduce performance
Choose file formats to optimize performance of Big SQL, JAQL, etc.
Make specific performance tuning decisions for Hive and HBase
Analyze performance considerations when using Apache Spark

Data Preparation, Transformation, and Export (26%)
Use Jaql query methods to transform data in InfoSphere BigInsights
Capture and prep social data for analytics
Integrating SPSS model scoring in InfoSphere Streams
Implement entity resolution within a Big Data platform (e.g. Big Match)
Utilize Pig for data transformation and data manipulation
Use Big SQL to transform data in InfoSphere BigInsights
Export processing results out of Hadoop (e.g. DataClick, DataStage, etc.)
Utilize consistent regions in InfoSphere Streams to ensure at least once processing

IBM Certified Data Engineer - Big Data

Job Role Description / Target Audience

This certification is intended for IBM Big Data Engineers. The Big Data Engineer works directly with the Data Architect and hands-on Developers to convert the architect's Big Data vision and blueprint into a Big Data reality. The Data Engineer possesses a deep level of technical knowledge and experience across a wide array of products and technologies. A Data Engineer understands how to apply technologies to solve big data problems, and has the ability to build large-scale data processing systems for the enterprise. Data engineers develop, maintain, test and evaluate big data solutions within organizations. They provide input on the needed hardware and software to the architects.

Big Data Engineers focus on collecting, parsing, managing and analyzing large data sets, in order to provide the right data sets and visual tools for analysis to the data scientists. They understand the complexity of data and can handle different data variety (structured, semi-structured, unstructured), volume, velocity (including stream processing), and veracity. They also address the information governance and security challenges associated with the data. They have a good background in software engineering and extensive programming and scripting experience.

To attain the IBM Certified Big Data Engineer, candidates must pass one test. To gain additional knowledge and skills, and prepare for the test based on the job roles and test objectives, click on the link to the test below and refer to the Test Preparation tab.

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)

Tuesday, May 16, 2017

Exam 77-886 SharePoint 2010

Published: June 30, 2011
Languages: English
Audiences: Information workers
Technology: Microsoft Office 2010 suites
Credit toward certification: MOS: SharePoint 2010

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. 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 and format content (25–30%)
Navigate the SharePoint hierarchy
Use Quick Launch, All Site Content, and breadcrumb trails; add content to Quick Launch; and use content and structure for navigation
Manage lists and libraries
Create lists or libraries, edit properties for new items, enable email notifications on a library or list, provide a shortcut to a mobile site URL, manage document templates, manage list views, create an alert on a list or library, enable rating, add a column, add content validation, manage column properties for various column types, and manage workflows
Manage list items
Create a new item, edit content, delete a list item or a document, version items, publish assets, manage workflows, and upload documents
Manage document sets
Create a document set, and add a document to a document set

Preparation resources
Site navigation overview (SharePoint Server 2010)
Manage lists and libraries with many items
Create and manage Document Sets

Manage SharePoint sites (15–20%)
Manage pages
Create, edit, and delete pages
Administer a site
Create a new site, configure the site structure, configure the Content Organizer, display a list of all user alerts, modify the look and feel of a site, and recover a list, library, document, or list item
Manage Web Parts on a page
Add a Web Part, configure a Web Part, hide or remove a Web Part, and export or import a Web Part
Manage content types
Associate a content type to a list, and extend the columns of a content type
Manage users and groups
Manage user access, groups, and group permissions
Create SharePoint workspace sites
Use document and meeting workspaces
Analyze site activity
View site web analytics, and view detailed reports

Preparation resources
Connect data in Web Parts
Manage membership of SharePoint groups

Participate in user communities (15–20%)
Configure My Site
Add keywords, add colleagues, select a theme, configure the Colleague Tracker Web Part, configure RSS feeds, and configure profiles
Collaborate through My Site
Update profile status, share pictures in My Site, manage personal documents, share documents in My Site, browse the organization hierarchy, and add Web Parts to My Site
Tag and note content
Add notes on the Note Board for a list or a library, add tags for a list or a library, rate an item, use tag clouds, and review tags on My Site

Preparation resources
Build a My Site profile to help people find you
Collaboration site planning (SharePoint Server 2010)
Social tagging overview (SharePoint Server 2010)

Configure and consume site search results (20–25%)
Administer search at the site level
Configure searchable columns, configure list search, and configure site search visibility
Search SharePoint for content
Perform search by using Windows Internet Explorer, Windows Explorer, Office Word 2010 Research Pane, or SharePoint Workspace 2010
View search results
Browse search results, use best bet results, use the refinement panel, use alerts and RSS feeds, and view document previews
Perform advanced searches
Use Boolean operators in searches, use wild cards in searches, run property searches, and run phonetic searches
Search for people
Use People Search, refine people searches, and use advanced searches

Preparation resources
Search for content
Quickly find the resources you need to get your job done
Customize the Search Center site

Integrate SharePoint 2010 services and Microsoft Office 2010 applications (15–20%)
Configure SharePoint 2010 services
Use Form Services, Excel Services, Access Services, and Visio Services
Run Microsoft Office 2010 applications with SharePoint 2010 services
Integrate with Microsoft Outlook, access content with SharePoint Workspace 2010, and integrate with Office Web Apps
Create dashboards
Create a dashboard page; add and configure the Key Performance Indicator (KPI) Web Part, KPI Details Web Part, Chart Web Part, Current User Filter Web Part, and Excel Web Access Web Part; display business data actions; and create KPI lists

Preparation resources
Getting started with Excel Services and Excel Web Access
Synchronize SharePoint 2010 content with Outlook 2010
Creating dashboards by using PerformancePoint Dashboard Designer

QUESTION 1
You need to perform a search for only PowerPoint files that contain the keyword ski.
Which method should you use?

A. Search for ski,and then select PowerPoint in the refinement panel.
B. Search for FileType:pptx, and then select ski In the refinement panel.
C. Click PowerPoint Presentations in the View All Site Content page, and then search for ski.
D. Perform an advanced search for PowerPoint, and then select skifrom the result type drop-down.

Answer: A
Explanation
The refinement options found on the left side of the results page provide drill-down capability filtered on the refinement and the general search results.

QUESTION 02
You need to display a list of all Microsoft Word documents in the site collection that contain the keyword ski. Which steps should you take?

A. 1. Navigate to the home page for the site.
    2. In the Document web part apply filters to the Type and Name columns.

B. 1. From Site Content and Structure, navigate to Documents tor the site.
    2. Apply filters to the Type and Name columns.

C. 1. Navigate to the home page for the site.
    2. Search using the search term ski.
    3. Refine the search to display Word documents.

D. 1. Navigate to the search page and perform an advanced search
    2. Specify ski as the Result
    3. Add a property restriction for the type Word.

Answer: C