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
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur TOPDOCTOR. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €9,73. Vous n'êtes lié à rien après votre achat.
