Which definition best describes RCAC?
A. It limits access by using views and stored procedures.
B. It grants or revokes certain directory privileges.
C. It limits the rows or columns returned based on certain criteria.
D. It grants or revokes certain user privileges - answer-C. It limits the...
Which definition best describes RCAC?
A. It limits access by using views and stored procedures.
B. It grants or revokes certain directory privileges.
C. It limits the rows or columns returned based on certain criteria.
D. It grants or revokes certain user privileges - answer-C. It limits the rows or columns returned
based on certain criteria.
You have a distributed file system (DFS) and need to set permissions on the the /hive/warehouse
directory to allow access to ONLY the bigsql user. Which command would you run?
A. hdfs dfs -chmod 700 /hive/warehouse
B. hdfs dfs -chmod 666 /hive/warehouse
C. hdfs dfs -chmod 770 /hive/warehouse
D. hdfs dfs -chmod 755 /hive/warehouse - answer-A. hdfs dfs -chmod 700 /hive/warehouse
What is an advantage of the ORC file format?
A. Efficient compression
B. Big SQL can exploit advanced features
C. Supported by multiple I/O engines
D. Data interchange outside Hadoop - answer-A. Efficient compression
You need to enable impersonation. Which two properties in the bigsql-conf.xml file need to be
marked true?
A. $BIGSQL_HOME/conf
B. DB2COMPOPT
C. bigsql.alltables.io.doAs
D. bigsql.impersonation.create.table.grant.public
E. DB2_ATS_ENABLE - answer-C. bigsql.alltables.io.doAs
D. bigsql.impersonation.create.table.grant.public
You are creating a new table and need to format it with parquet. Which partial SQL statement
would create the table in parquet format?
A. STORED AS parquet
B. CREATE AS parquetfile
C. STORED AS parquetfile
D. CREATE AS parquet - answer-C. STORED AS parquetfile
Which directory permissions need to be set to allow all users to create their own schema?
A. 666
B. 777
C. 700
D. 755 - answer-B. 777
You need to determine the permission setting for a new schema directory. Which tool would you
use?
A. umask
B. GRANT
C. HDFS
D. Kerberos - answer-A. umask
,Using the Java SQL Shell, which command will connect to a database called mybigdata?
A. ./jsqsh mybigdata
B. ./jsqsh go mybigdata
C. ./java mybigdata
D. ./java tables - answer-A. ./jsqsh mybigdata
Which two commands would you use to give or remove certain privileges to/from a user?
A. INSERT
B. GRANT
C. REVOKE
D. LOAD
E. SELECT - answer-B. GRANT
C. REVOKE
What are Big SQL database tables organized into?
A. Schemas
B. Directories
C. Files
D. Hives - answer-A. Schemas
When connecting to an external database in a federation, you need to use the correct database
driver and protocol. What is this federation component called in Big SQL?
A. Wrapper
B. Data source
C. User mapping
D. Nickname - answer-A. Wrapper
Which statement best describes a Big SQL database table?
A. A directory with zero or more data files.
B. The defined format and rules around a delimited file.
C. A container for any record format.
D. A data type of a column describing its value - answer-A. A directory with zero or more data
files
Which tool would you use to create a connection to your Big SQL database?
A. Jupyter
B. DSM
C. Ambari
D. Scheduler - answer-B. DSM
What is the default directory in HDFS where tables are stored?
A. /apps/hive/warehouse/schema
B. /apps/hive/warehouse/
C. /apps/hive/warehouse/data
D. /apps/hive/warehouse/bigsql - answer-B. /apps/hive/warehouse/
Which command creates a user-defined schema function?
A. ALTER MODULE PUBLISH FUNCTION
B. TRANSLATE FUNCTION
C. ALTER MODULE ADD FUNCTION
D. CREATE FUNCTION - answer-D. CREATE FUNCTION
Apache Spark provides a single, unifying platform for which three of the following types of
operations?
, A. graph operations
B. record locking
C. batch processing
D. machine learning
E. ACID transactions
F. transaction processing - answer-A. graph operations
C. batch processing
D. machine learning
Which is the java class prefix for the MapReduce v1 APIs?
A. org.apache.hadoop.mr
B. org.apache.mapreduce
C. org.apache.hadoop.mapred
D. org.apache.mr - answer-C. org.apache.hadoop.mapred
What is the preferred replacement for Flume?
A. Hortonworks Data Flow
B. Storm
C. NiFi
D. Druid - answer-A. Hortonworks Data Flow
Under the YARN/MRv2 framework, which daemon arbitrates the execution of tasks among all the
applications in the system?
A. ScheduleManager
B. ApplicationMaster
C. JobMaster
D. ResourceManager - answer-D. ResourceManager
Which component of the Apache Ambari architecture provides statistical data to the dashboard
about the performance of a Hadoop cluster?
A. Ambari Wizard
B. Ambari Alert Framework
C. Ambari Metrics System
D. Ambari Server - answer-C. Ambari Metrics System
Under the YARN/MRv2 framework, the Scheduler and ApplicationsManager are components of
which daemon?
A. ResourceManager
B. ApplicationMaster
C. TaskManager
D. ScheduleManager - answer-A. ResourceManager
Which three programming languages are directly supported by Apache Spark?
A. Scala
B. Java
C. C++
D. Python
E. .NET
F. C# - answer-A. Scala
B. Java
D. Python
Under the YARN/MRv2 framework, the JobTracker functions are split into which two daemons?
A. JobMaster
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller TOPDOCTOR. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
