File Info
| Exam | IBM Big Data Engineer |
| Number | C2090-101 |
| File Name | IBM.C2090-101.Train4Sure.2018-11-22.28q.tqb |
| Size | 92 KB |
| Posted | Nov 22, 2018 |
| Download | IBM.C2090-101.Train4Sure.2018-11-22.28q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?
- join
- group
- expand
- transform
Correct answer: B
Explanation:
Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y#v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key%20values%20and%20applies%20an%20aggregate%20expression&f=false Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y#v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key%20values%20and%20applies%20an%20aggregate%20expression&f=false
Question 2
Which of the following are CRUD operations available in HBase? (Choose two.)
- HTable.Put
- HTable.Read
- HTable.Delete
- HTable.Update
- HTable.Remove
Correct answer: AC
Explanation:
Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm
Question 3
Which statement is TRUE about Big SQL?
- The table definition can include other attributes such as the primary key or check constraints
- When using Big SQL, the CREATE TABLE statement cannot be embedded in an application program
- If a sub-table is being defined, the authorization ID can be either the same as the owner of the root table or an equivalent
- When defining a staging table associated with a materialized query table, the privileges held by the authorization ID of the statement only works with DBADM authority
Correct answer: D
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/fi/SSCRJT_5.0.2/com.ibm.swg.im.bigsql.commsql.doc/doc/r0000927.html Reference: https://www.ibm.com/support/knowledgecenter/fi/SSCRJT_5.0.2/com.ibm.swg.im.bigsql.commsql.doc/doc/r0000927.html
