Download IBM.C2090-101.Train4Sure.2018-11-22.28q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-101 |
| Exam Name: | IBM Big Data Engineer |
| Date: | Nov 22, 2018 |
| File Size: | 92 KB |
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
