Exam Code: C2090-317 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 11 System Administrator for z/OS
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-317 Exam.
2021 May C2090-317 Study Guide Questions:
Q1. Which two features are the motivation behind the conversion to extended RBA/LRSN format?
A. Greater RECOVER utility concurrency.
B. Reduction of the potential for an RBA rollover.
C. More precise PIT recovery of the DB2 system catalog and directory.
D. Potentially faster UPDATE performance due to greater LRSN granularity.
E. Reduced p-Lock contention in the coupling facility due to greater LRSN granularity.
Answer: C
Q2. In complex DB2 recovery scenarios, it is important to understand the scope of which objects require recovery.
Which DB2 utility provides a list of the names of all table spaces in the table space set that is specified and a list of all the tables in those table spaces?
A. CHECK
B. REPORT
C. QUIESCE
D. RECOVER
Answer: D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/d b2z_reportsyntax.dita
Q3. Which statement is true regarding DB2 definitions for SMF collection?
A. SMF collection is not required for DB2.
B. At the minimum, DB2 statistics class 1 trace is required.
C. At the minimum. DB2 accounting classes 1.2.3 are required.
D. The SMF subsystem does not have to be active for DB2 to write SMF trace records.
Answer: B
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.inst/src/tpc/db 2z_recorddb2data2smfdsenable.dita(See the table, second row)
Replace C2090-317 download:
Q4. How can you create a dynamic location alias?
A. Use the CREATE ALIAS statement.
B. Issue the -MODIFY DDF ALIAS ADD command.
C. INSERT a dynamic alias row into SYSIBM.LOCATIONS.
D. Execute the DSNJU003 utility with a DDF ALIAS statement.
Answer: D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.comref/src/tpc /db2z_cmd_modifyddf.dita
Q5. Which action should you take to improve the performance of authorization checking for stored procedures or user-defined functions?
A. Set subsystem parameter EXTSEC to YES.
B. Increase the value of subsystem parameter SECQTY.
C. Increase the value of subsystem parameter AUTHCACH.
D. Increase the value of subsystem parameter CACHERAC.
Answer: D
Explanation:Reference:http://www.redbooks.ibm.com/redbooks/pdfs/sg247134.pdf(page 336)
Q6. Your database administrators plan to start using XML and they plan to have the XML
documents being validated using type modifiers.
You must make sure that they are able to make XSR schemas available for this.
Which stored procedure(s), if any, must at least be created and functioning for that?
A. XSR_REGISTER
B. XSR_REGISTER, XSR_COMPLETE
C. No stored procedures need to be created.
D. XSRREGISTER. XSRCOMPLETE. XSRADDSCHEMADOC
Answer: B
Precise C2090-317 questions:
Q7. Which statement regarding DSN1LOGP is FALSE?
A. DSN1 LOGP does not require DB2 privileges.
B. DSN1 LOGP runs on archive data sets when DB2 is running.
C. DSN1 LOGP can read logs that have been compressed by DFSMS.
D. DSN1 LOGP can print the log records for both base and clone table objects.
Answer: C
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/d b2z_utl_dsn1logp.dita(search for read logs)
Q8. If a DB2 subsystem fails during start up in the log initialization phase, which two steps are needed in your corrective actions to minimize impact without completing a cold start?
A. Start DB2 using DEFER ALL.
B. Use DSNJU003 with the ENDRBA option.
C. Use DSNJU003 with the STARTRBA option.
D. Start DB2 using DEFER on catalog and directory.
E. Recover the subsystem to the last known system checkpoint in BSDS.
Answer: D,E
Q9. Having to deal with data inconsistency during a disaster recovery can significantly impact the length of time needed to recover. One of the actions that could be taken to prevent this from occurring is to not take an image copy of a data set that contains inconsistent data.
Which two options can be used to help prevent taking an image copy of inconsistent data?
A. Run the DIAGNOSE utility before making an image copy.
B. Run the CHECK DATA utility before making an image copy.
C. Use the CHECKPAGE option when running the COPY utility.
D. Prior to making an image copy, run DSN1 COPY with the CHECK option.
E. At install time, use the DSNTIJIC install job to take a full image copy of the DB2 catalog and directory.
Answer: C,D
Explanation:Reference:http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.ugref/src/tpc/d b2z_checkinconsistentdata.dita
Q10. Which statement regarding migration from DB2 10 for z/OS to DB2 11 for z/OS is true?
A. All packages must be rebound with application compatibility set to V10R1.
B. The DB2 catalog and directory must be changed to reside on SMS managed DASD.
C. All packages last bound prior to DB2 9 for z/OS must be rebound in DB2 10 or DB2 11.
D. The size of the DB2 bootstrap datasets must be increased to accommodate a larger LRSN and RBA length.
Answer: A