Premium

IBM Certified Data Architect - Big Data Certification Questions and Answers (Dumps and Practice Questions)



Question : IBM BigSheets is a revolutionary browser-based analytics tool that enables business users to extend the scope of their intelligence data through the web in a timely
manner.

: IBM BigSheets is a revolutionary browser-based analytics tool that enables business users to extend the scope of their intelligence data through the web in a timely
1. True
2. False

Correct Answer : 1
Explanation: IBM BigSheets is a revolutionary browser-based analytics tool that enables business users to extend the scope of their intelligence data through the web
in a timely manner. It is a UI developed specifically for business intelligence and non-technical business users to facilitate data gathering and analysis. BigSheets the ability
to gather data in structured form (databases, etc.) and un-structured form (web sites, documents, etc.). By allowing the combination of these two data sources, BigSheets allows
business users ID opportunities and risks "hidden in the data"
BigSheets enables a quick return for the investment: it has been designed to be used by line of business professionals to rapidly gather insights and analysis from enormous
amounts of data...and to be able to act on those insights in a timely manner. No need to understand database schemas, no need to understand a query language. BigSheets does the
hard work "behind the scenes" allowing business decision makers the opportunity to concentrate on generating business value.





Question : Big SQL supports querying data, but does not support SQL UPDATE or DELETE statements. INSERT statements
: Big SQL supports querying data, but does not support SQL UPDATE or DELETE statements. INSERT statements
1. True
2. False

Correct Answer : 1
Explanation: In such situations and others, Big SQL can play an important role. However, it's inappropriate to think of Big SQL as a replacement for relational DBMS
technology. Big SQL was designed to complement and leverage the Hadoop-based infrastructure in BigInsights. Certain features common to relational DBMS systems aren't present in
Big SQL, and certain Big SQL features aren't present in most relational DBMS systems. For example, Big SQL supports querying data, but does not support SQL UPDATE or DELETE
statements. INSERT statements are supported only for HBase tables. Big SQL tables may contain columns of complex data types such as struct and array, rather than simply "flat" rows.





Question : Which of the following statements are correct?
: Which of the following statements are correct?
1. BIG SQL is ANSI 2011 Compliant

2. BIG SQL is supported to work with Cloudera

3. BIG SQL supports Fluid Query

4. 2 and 3

5. 1,2 and 3

Correct Answer : 5
Explanation:


Related Questions

Question : You have a file bases data source. Where data is continuously added. Now ,you need to import this data in Hadoop , HDFS. Which of the following tool help you to
implement this?
 : You have a file bases data source. Where data is continuously added. Now ,you need to import this data in Hadoop , HDFS. Which of the following tool help you to
1. Sqoop

2. Pig

3. Access Mostly Uused Products by 50000+ Subscribers

4. Flume

5. BigSQL


Question : Which of the following feature is supported by IBM GPFS
: Which of the following feature is supported by IBM GPFS
1. There is a requirement where logical isolation and physical isolation need to be supported

2. There is a requirement for separate clusters for analytics and databases

 3. Access Mostly Uused Products by 50000+ Subscribers

4. There is a need to run the NameNode in a separate high availability environment


Question : You are creating an hadoop based solution. You need to consider archival size of the cluster. Which of the following , you need to consider for deciding the cluster
archival size?
 : You are creating an hadoop based solution. You need to consider archival size of the cluster. Which of the following , you need to consider for deciding the cluster
1. Replication factor

2. Number of nodes required

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Number of batches


Question : In Hadoop YARN based cluster, which of the following needs to be configured for High Availabilty?
 : In Hadoop YARN based cluster, which of the following needs to be configured for High Availabilty?
1. JobTracker

2. TaskTracker

 3. Access Mostly Uused Products by 50000+ Subscribers

4. DataNode


Question : 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 company has to design a new data system. They will need to support several
1. Use a NoSQL data store such as MongoDB or Cloudant on the cloud to provide needed scalability

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

 3. Access Mostly Uused Products by 50000+ Subscribers

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


Question : Which data format stores all of the data in a binary format making the files more
compact, and will even add in markers to help Map Reduce jobs determine where to break large files for more efficient processing?

 : Which data format stores all of the data in a binary format making the files more
1. Parquet

2. Avro

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Sequence File

5. Map File