IBM Big Data Architect (C2090-102) Free Practice Test

Question 1

Which of the following statements is TRUE regarding Cloud deployment models?

A. Applications with extremely high transactions volumes are good candidates for Platform as a Service

B. Performance and scalability requirements are a critical factor for deciding between Platform as a Serviceand Infrastructure as a Service deployment models

C. In a platform as a Service offering, the customer has root access to the servers

D. In an infrastructure as a service deployment, the cloud provider provides security patching, monitoring andfail over capabilities

Correct Answer: B

Question 2

A company has to design a new data system. They will need to support several OLTP applications. Every three days a batch job will run to load specific data into a set of 10 large tables (with historical data) where OLAP analytics will be performed. Performance for both OLTP and OLAP queries is important. Which of the following designs would you suggest to the company?

A. Use a NoSQL data store such as MongoDB or Cloudant on the cloud to provide needed scalability

B. Use DB2 Data Partition Feature (DPF), partitioning all tables into different partitions

C. Use DB2 with BLU Acceleration, use columnar store for the 10 tables where Analytics will be run

D. Use DB2 Data Partition Feature (DPF), only partitioning the 10 tables where Analytics will be run

Correct Answer: C

Question 3

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. Oozie with Lucene

B. Nagios with Lucene

C. Text Analytics with OPTIM performance Manager

D. HBase together with OPTIM performance Manager

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You are asked to provide deep analytics from existing historical data to score new high volume incoming live data with low latency in real time. Which of the following would you suggest?

A. Hive with MapReduce

B. SPSS Modeler with InfoSphere Streams

C. InfoSphere DataStage with InfoSphere Streams

D. Cassandra with YARN

Correct Answer: C

Question 5

Which one of the following statements about Big SQL is TRUE?

A. Executing Big SQL queries through MapReduce framework would always be a better choice

B. Big SQL processes queries locally either on disk or in memory

C. Big SQL supports updates in Hive.

D. Big SQL doesn't need any secondary indices to access HBase tables

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Data stored in Netezza can be used for model building, scoring, and model refresh. How is SPSS Modeler connectivity to Netezza enabled?

A. Java Database Connectivity (JDBC) driver provided by Netezza

B. DataDirect Connect for ODBC drivers

C. Open Database Connectivity (ODBC) driver provided by Netezza

D. OLE DB drivers provided by Netezza

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

IBM Big Data Architect (C2090-102) Free Practice Test