100%合格率リアルA00-415試験成功を掴み取れ！[2024年10月]
SASInstitute A00-415のPDF問題格別な練習SAS Viya Fundamentals of Programming
質問 # 30
Given the following SAS program:
data casuser.national;
set casuser.baseball(where=(league='National'));
r=ranuni(625);
drop league;
run;
Why is the above program processed by the Compute Server rather than the CAS server?
- A. The RANUNI function is not supported.
- B. The SESSREF= optionis not specified in the DATA statement.
- C. The DROP statement is not supported.
- D. The WHERE option is not supported in the SET statement.
正解：A
質問 # 31
Which CAS-enabled procedure is used to apply user-defined formats to variables?
- A. CASTABULATE
- B. CASPROC
- C. CASUTIL
- D. CASFORMAT
正解：A
質問 # 32
In order to use a user-defined format in CAS, which condition must be true?
- A. The system option CASFORMATS=True must be specified.
- B. The format name must begin with the prefix 'cas'.
- C. The format must be saved to the FORMATS caslib.
- D. The format must exist in a CAS format library.
正解：D
質問 # 33
Which CAS action is used to perform a join operation between two CAS tables based on a common key variable?
- A. cas.join
- B. cas.merge
- C. cas.combine
- D. cas.link
正解：A
質問 # 34
Which CAS action is used to delete a CASLIB?
- A. ALTER TABLE
- B. CASLIB
- C. EXPORT
- D. DROP TABLE
正解：B
質問 # 35
Which statement correctly creates a global caslib called mycas that is connected to the
/workshop/data location?
- A. caslib mycas path="/workshop/data" promote;
- B. caslib path="/workshop/data" mycas promote;
- C. caslib mycas path="/workshop/data" global;
- D. caslib path="/workshop/data" mycas global;
正解：C
質問 # 36
Which statement can execute successfully using PROC FEDSQL?
- A. create table casuser.incomplete as
select AgeAtStart, Height, cholesterol, Chol_Status
from casuser.heart
where cholesterol is null
; - B. select HouseID, Brand, exp(logPrice) as Price
from casuser.margarin
where calculated Price > 5
; - C. create table work.age12 as
select Name, Height, Weight
from casuser.class
where age=12
; - D. select Species, SepalWidth, SepalLength
from casuser.iris
where Species ^= "Setosa"
;
正解：A
質問 # 37
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
- A. PROC GLM
- B. PROC MEANS
- C. PROC SQL
- D. PROC FREQ
正解：D
質問 # 38
Which CAS statement is used to load data from an external file into a CAS table?
- A. CASIMPORT
- B. CASTABLE
- C. CASLIB
- D. CASDATA
正解：A
質問 # 39
Which CAS action is used to merge two or more CAS tables based on common variables?
- A. ALTER TABLE
- B. LOAD
- C. MERGE
- D. EXPORT
正解：C
質問 # 40
Which CAS action is used to remove duplicate records from a CAS table?
- A. cas.dedup
- B. cas.distinct
- C. cas.unique
- D. cas.remove
正解：A
質問 # 41
What is the primary programming language used in SAS Viya?
- A. Python
- B. Java
- C. SAS
- D. R
正解：C
質問 # 42
Which CAS action is used to filter rows in a CAS table based on specified conditions?
- A. cas.where
- B. cas.subset
- C. cas.filter
- D. cas.select
正解：A
質問 # 43
Which CAS action is used to validate the integrity of relationships between variables in a CAS table?
- A. cas.relationship
- B. cas.validate
- C. cas.integrity
- D. cas.link
正解：A
質問 # 44
What is the purpose of the GROUP BY clause in SQL programming?
- A. To group rows based on common values
- B. To define the output columns
- C. To sort the result set
- D. To filter rows based on conditions
正解：A
質問 # 45
What is the purpose of the APPEND action in CAS language programming?
- A. To add new observations to an existing CAS table
- B. To merge multiple CAS tables horizontally
- C. To concatenate multiple CAS tables vertically
- D. To append columns to an existing CAS table
正解：A
質問 # 46
Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?
- A. cas.frequency
- B. cas.count
- C. cas.distinct
- D. cas.uniq
正解：D
質問 # 47
Which CASL program will create the sample2 table in the casuser caslib?
- A. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class;
by age;
if first.age then y=age;
run;
";
quit; - B. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class;
y=ranuni(123)*100;
run;
";
run; - C. proc cas;
datastep.runCode result=r/
code="
data casuser.sample2;
set casuser.class(firstobs=3);
run;
";
quit; - D. proc cas;
datastep.runCode result=r/
code="
data casuser.sample1;
set casuser.class;
y=1;
run;
data casuser.sample2;
set casuser.class;
y=2;
run;
";
quit;
正解：A
質問 # 48
Which CAS action is used to calculate the sum, minimum, maximum, and mean for numeric variables in a CAS table?
- A. cas.statistics
- B. cas.describe
- C. cas.summarize
- D. cas.aggregate
正解：C
質問 # 49
Which CAS-enabled procedure is used to perform data exploration and summarization?
- A. CASSTAT
- B. CASPROC
- C. CASUTIL
- D. CASDATA
正解：A
質問 # 50
Which CASL statement correctly saves a SAS data set keeping only the empid and hrdate variables?
- A. table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate", table={caslib="casuser", name="emp", keep={{name="empid"}, {name="hrdate"}}};
- B. table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate", table={caslib="casuser", name="emp", vars={{name="empid"}, {name="hrdate"}}};
- C. table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate", table={caslib="casuser", name="emp", keep={"empid", "hrdate"}};
- D. table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate", table={caslib="casuser", name="emp", vars={"empid", "hrdate"}};
正解：D
質問 # 51
......
SAS VIYAプログラミング試験の基礎は、SAS VIYAプログラミングで知識とスキルを実証したい個人のためにSAS研究所が提供する認定試験です。この試験は、SAS VIYAを使用してデータにアクセス、管理、操作し、データ分析とレポートを実行し、SAS VIYAプログラムを開発する候補者の能力をテストするように設計されています。
SASInstitute A00-415 試験に合格すると、SAS Certified Specialist: SAS Viya Fundamentals of Programming 認定を取得することができます。この認定は、個人が SAS Viya でアプリケーションを開発・展開し、大規模なデータセットを扱い、洞察を抽出し、データに基づく意思決定を行うスキルと知識を持っていることを示しています。
A00-415問題集GoShiken100%合格率保証：https://www.goshiken.com/SASInstitute/A00-415-mondaishu.html
A00-415試験問題集を使って最速合格：https://drive.google.com/open?id=1gpmUbF7Nn10GcClKFTXXsZ3rMbs2uUu-