IBM C2090-102 Free Practice Questions

NEW QUESTION 1
In BigSheets you can add sheets to workbooks to progressively edit and explore your data. Which of the following is a CORRECT list of types of sheets that BigSheets provides and can contain predefined logic for analyzing data?

• A. Copy, Formula, Update
• B. Filter, Insert, Union
• C. Distinct, Join, Stored Procedure
• D. Complement, Limit, Group

Answer: D

Explanation:
References:
https://developer.ibm.com/hadoop/blog/2014/08/18/use-bigsheets-analytics/

NEW QUESTION 2
Which of the following is a key consideration when determining the potential use of Models in Big Data Deployments?

• A. Stability of schema
• B. Level of Information Processing
• C. Ownership/Governance
• D. All of the above

Answer: B

NEW QUESTION 3
A media company wants to enhance their subscription services to their end customers by incorporating Twitter, Wikis, Blogs, and Analysts data. The company likes to provide a real- time dashboard view for news articles, press releases, andanalysts perspective to end customers based on their subscriptions. What solution blueprint would offer the best fit for this critical business
requirement?

• A. Watson Analytics
• B. Big Insights, Spark, and Big SQL
• C. Pure Data for Analytics PDA, and SPSS
• D. InfoSphere Streams, BigInsights, and Watson Explorer

Answer: D

NEW QUESTION 4
Which of the following statements is TRUE regarding cloud computing solutions?

• A. Cloud security is planned, developed, and layered on top of an application after the application development process is complete
• B. Stateless applications are better candidates for cloud services than applications that maintain state
• C. Cloud solutions rely on scaling up (vertical) scaling v
• D. scale out (horizontal) scaling
• E. Server virtualization is a requirement in a cloud implementation

Answer: D

NEW QUESTION 5
Which architecture document is used to help organize projects, manage the complexity of the solution, and ensurethat all architecturerequirements have been addressed?

• A. Operational Model
• B. Component Model
• C. Connection Model
• D. API Model

Answer: B

NEW QUESTION 6
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

NEW QUESTION 7
You need to set up a distributed storage system for being able to process very large data sets and you want to be able to leverage the Open Data Platform (ODP) Core. Which one of the following would you use?

• A. Apache Spark
• B. IBM GPFS
• C. EMC Isilon
• D. HDFS

Answer: B

NEW QUESTION 8
Big data is often defined as the ability to derive new insights from data that has scaled up along three axes known as the three v’s. Which of the following is the fourth v? (Hint: It has something to do with the uncertainty.)

• A. volume
• B. variety
• C. velocity
• D. veracity

Answer: C

NEW QUESTION 9
Defining your need to enrich existing customer data you realize that you need to process large quantities of Geospatial data and output to your data warehouse in a standard GeoJSON format. Which of the following would provide a business analyst with the desired output?

• A. Big SQL
• B. BigSheets
• C. Hive queries
• D. Text Analytics

Answer: C

NEW QUESTION 10
As data architect, understanding where patient data resides, how is it related, and how you define security and privacy policies requires knowledge of each of the following?

• A. PII Data
• B. HIPAA Requirements
• C. Privacy by design
• D. Data storage in HDFS

Answer: B

NEW QUESTION 11
You are consulting with a company to design a new Big Data System. The CIO insists that all components must be open source. The key requirement is to provide text search on their data. For audit purposes the infrastructure must also be monitored and an alert system in place. To meet these requirements, which of the following would you suggest?

• A. HBase together with OPTIM performance Manager
• B. Text Analytics with OPTIM performance Manager
• C. Nagios with Lucene
• D. Oozie with Lucene

Answer: C

Explanation:
References: https://www.nagios.org/ https://www.ibm.com/support/knowledgecenter/SSPT3X_2.1.2/ com.ibm.swg.im.infosphere.biginsights.product.doc/doc/bi_addtl_technologies.ht ml

NEW QUESTION 12
Which of the following does NOT consist of collaboration from various organizations to drive innovation and standardization across big data technologies?

• A. Cloudera Enterprise
• B. Hortonworks Data Platform
• C. IBM BigInsights
• D. Pivotal Big Data Suite

Answer: C

Explanation:
Reference:
http://www-01.ibm.com/software/data/bigdata/business-partner.html

NEW QUESTION 13
BigInsights is a solution that accomplishes which of the following?

• A. Replaces the traditional Data warehouses
• B. Can exchange information with the traditional Data warehouses only
• C. Includes a connector that enables data exchange between a BigInsights cluster and Netezza appliance in only one way
• D. Supports data exchange with a number of sources

Answer: C

Explanation:
Reference:
https://www- 01.ibm.com/support/knowledgecenter/SSPT3X_2.1.1/com.ibm.swg.im.infosphere.biginsight s.install.doc/Install.pdf

NEW QUESTION 14
Which of the following approaches can an organization take to solve the impact on the performance and capacity originated by the variety of data types?

• A. Define a data catalog in a traditional data warehouse
• B. Create different solutions to handle every kind of data
• C. Store a wide range of data formats on the same platform
• D. Define a comprehensive taxonomy and constantly review

Answer: D

Explanation:
Reference:
http://www.redbooks.ibm.com/redpapers/pdfs/redp5070.pdf Page: 15

NEW QUESTION 15
Considering a service level requirement (SLR) of less than 3 milliseconds, what task must be performed to meet the SLR?

• A. Collect and analyze SNMP MIB data
• B. Survey a representative amount of end users
• C. Measure switch failure frequency
• D. Inquire when prime network hours occur

Answer: C

NEW QUESTION 16
Which of the following statements is true about DB2 BLU?

• A. To move a table from row based into a BLU columnar format you have to take a back up and restore it to a BLU table.
• B. To move a table from row based into a BLU columnar format you need to take it offline and do a one time convert into a BLU table.
• C. To support mixed workload it is necessary to create a shadow copy of the relevant tables.
• D. To support mixed workload it is necessary to create a shadow copy of the database populated with relevant BLU tables.

Answer: B

Explanation:
Reference:
https://www.ibm.com/developerworks/library/dm-1406convert-table-db2105/

NEW QUESTION 17
Which of the following is NOT a valid Big Data platform integration?

• A. Platform plugins
• B. Intraplatform integration
• C. Enterprise integration with other repositories
• D. Network integration

Answer: D

NEW QUESTION 18
Which one of the following statements is TRUE?

• A. Big SQL uses Hadoop MR framework to process query tasks in parallel
• B. Big SQL executes queries locally on Big SQL server single node on a multi node cluster
• C. Big SQL can process queries in parallel and executes queries locally
• D. Big SQL only works with HDFS

Answer: A

Explanation:
Reference:
https://www- 01.ibm.com/support/knowledgecenter/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsight s.analyze.doc/doc/bigsql_performance.html

NEW QUESTION 19
An upstream Oil and Gas Producer needs to optimize the performance of its assets. It needs to calculate Key Performance Indicators for flow rate sensors deployed to monitor the output flow and temperature and pressure for multiple pipelines in an oil field with hundreds of wells. Which of the following would you recommend to meet these requirements?

• A. Datastage ETL jobs should be created
• B. Infosphere Streams should be used
• C. Cognos reports would suffice here
• D. Hadoop based datastorage engine should be used

Answer: B

NEW QUESTION 20
In order to enable connectivity between Netezza and BigInsights, what must be enabled on the Netezza Performance Server?

• A. Java-based Netezza user-defined functions
• B. ODBC drivers from Netezza
• C. JDBC drivers from Netezza
• D. JAQL Netezza connectors

Answer: A

Explanation:
Reference:
https://www-01.ibm.com/support/knowledgecenter/SSPT3X_4.1.0/com.ibm.swg.im.infosphere. biginsight s.import.doc/doc/data_warehouse_udf_netezza.html

NEW QUESTION 21
A major telecommunication company has millions of customers. Most of their customers are prepaid. Being prepaid customers, they can very easily switch to other vendors. The last four to six months, this company has lost quite a good number of customers to competition. They intend to build a system that can provide them with insight into the customer’s social network (e.g. who is the influencer and who is the follower). They also want the ability to monitor the voice
and data usage patterns in real time and they want the system to be trained over time to predict possible dissatisfactions. Given this scenario, which one of the following would you recommend?

• A. Hadoop
• B. Spark
• C. Cloudant
• D. Netezza

Answer: B

NEW QUESTION 22
A financial company stores all enterprise data for five years in their Teradata data warehouse that costs them expensive storage. The company started an initiative to move historical data to a Hadoop environment and uses federation method to access both sets of data. What would be the IBM Big Data value proposition for this use case?

• A. IBM Logical Data Warehouse and IBM Big SQL
• B. Enterprise Data Warehouse
• C. Pure Data for Analytics
• D. InfoSphere Information Server

Answer: A

NEW QUESTION 23
A telecommunication company needs a Big Data solution that could store and analyze multiple years worth of call detail records (CDRs, aprox. 17 billion events per day) containing switch, billing, and network event data for its millions of subscribers. Which of the following would you recommend for these requirements?

• A. Infosphere DataStage
• B. DB2
• C. Pure Data System for Analytics
• D. SPSS

Answer: C

NEW QUESTION 24
......