Oracle

 Question #29 Topic 1 HOTSPOT -  You have a folder of monthly transaction extracts. You plan to create a report to analyze the transaction data. You receive the following email message: `Hi, I've put 24 files of monthly transaction data onto the shared drive. File Transactions201801.csv through Transaction201812.csv have four columns while files Transactions201901.csv through Transaction201912.csv have the same four columns plus an additional three columns. Each file contains 10 to 50 transactions.` You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.) x  https://www.examtopics.com/exams/microsoft/da-100/custom-view/ 26/169  The columns used are based on the entire dataset. The additional columns in the 2019 files will be detected. Box 3: Yes - Note: Under the hoods, Power BI will automatically detect which delimiter to use, and may even promote the first row as headers. You can manu...

 You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: ✑ Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. ✑ Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function. B. Create one-to-many relationships between the tables. C. Create a calculated measure that aggregates by using the COUNTROWS function. D. Create a calculated table that contains Ad_id, Site_name, and Impression_date. Correct Answer: AB Community vote distribution AB (83%) U (17%) 2/16/22, 10:49 PM DA-100 Exam – Free Actual Q&As, Page 1 | ExamTopics https://www.examtopi...